Delete Calculation Table Rows
The Delete Calculation Table Rows task will delete the specified rows from the nominated Calculation Table Name.
|Field Names||The column names to match against, delimited by pipe bars "|" if more than one field is to be matched against.|
|Match Values||The values to match against based on the fields specified in the Field Names property. Values should be delimited by pipe bars "|" and be in the same order as the field names.|
|Table Name||The name of the Calculation 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||Amazon Warriors|Munich Marshalls||These values will be looked for in the Calculation Table. Matching rows will be deleted.|
|Table Name||"Customers"||Customers||Customers is the name of the Calculation Table to delete these rows from.|
Export To Calculation Table