DriveWorks Pro 15: Delete Calculation Table Rows [send feedback...]

Delete Calculation Table Rows

The Delete Calculation Table Rows task will delete the specified rows from the nominated Calculation Table Name.

Properties

Property NameDescription
Field NamesThe column names to match against, delimited by pipe bars "|" if more than one field is to be matched against.
Match ValuesThe 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 NameThe name of the Calculation Table to remove rows from.
TitleChanges the Title (not the name) of the task.

Example Data

IDCompany NameCityCountry
1Amazon WarriorsStrasbourgFrance
2TT TigersOldenburgGermany
3Super JetsTrevisoItaly
4Munich MarshallsMunichGermany
5Super LeagueGranadaSpain

Example

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.

PropertyExample RuleExample ResultMeaning
Field Names"Company Name"Company NameCompany Name will be used as the Field to match values against.
Match ValuesDWVariableCustomerListAmazon Warriors|Munich MarshallsThese values will be looked for in the Calculation Table. Matching rows will be deleted.
Table Name"Customers"CustomersCustomers is the name of the Calculation Table to delete these rows from.

Result Data

IDCompany NameCityCountry
2TT TigersOldenburgGermany
3Super JetsTrevisoItaly
5Super LeagueGranadaSpain

See Also

Calculation Tables

Export To Calculation Table

Table of Contents