The Delete Simple Table Rows task will delete the specified rows from the nominated Simple Table Name.
|Field Names||The column names to match against, delimited by pipe bars "|".|
|Match Values||The values to match against based on the fields specified in the Field Names property. Values should be delimited by pipe bars "|".|
|Table Name||The name of the Simple Table to remove rows from.|
|Title||Changes the Title (not the name) of the task.|
When this task is added the properties are static by default.
See How To: Change A Static Property To A Dynamic Property to enable rules to be built on these properties.
|Property||Example Rule||Example Result||Meaning|
|Field Names||"Company Name"||Company Name||Company Name will be used as the Field to match values against.|
|Match Values||DWVariableCustomerList||TT Tigers|Super Jets||These values will be looked for in the Simple Table. Matching rows will be deleted.|
|Table Name||"Customers"||Customers||Customers is the name of the Simple Table to delete these rows from.|
DriveWorks Tech Tips Portal
Shows how you can copy data from one Simple Table to another, remove selected rows and clear the whole table using macros.
Editing Table Data
This project shows how to add, edit and delete data from a Simple Table. The methods used in this can be transferred to Group Tables and also SQL Tables.