Home Search

DriveWorks Pro 21
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.

When using pipebar delimited lists (|) to delete from multiple columns please note you can only match ONE item for each column to delete having specified the columns in the Field Names property and the Items in the Match Values property.

You can not use a pipebar delimited list to delete multiple different items from the same column. You can only delete multiple of the same item from a column.

It is important to make sure that the number of items in the Match Values property is the same as the number of columns specified in the Field Names.

If you specify two columns to look in for the Field Names property you must make sure you have two items specified for the Match Values property as well.

Deleting all Calculation Table rows will not affect any Column Rules applied.

When rows are re-added (when using the Export To Calculation Table document, for example) any Column Rules applied previously will be re-applied.

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.

Outputs

This task has different types of Outputs. For more information about Outputs see Specification Macros Task Node.

Outputs are only available within Specification Macros. Currently Outputs are not available Specification Flow.

Data Outputs

Output NameDescription
Deleted Rows CountThis is the number of rows deleted from the table.

Status Outputs

This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.

The status output navigation is as follows:

Success

  • Successfully deleted rows.

Success with warnings.

  • N/A

Failed (one of the following occurred)

  • Calculation table not found.
  • General error - see Specification report for more information.

Examples

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.

Example Data

IDCompany NameCityCountry
1Amazon WarriorsStrasbourgFrance
2Amazon WarriorsMunichGermany
3Super JetsTrevisoItaly
4Super LeagueLeedsEngland
5Super LeagueGranadaSpain

One Column

PropertyExample RuleExample ResultMeaning
Field Names"Company Name"Company NameCompany Name will be used as the Field to match values against.
Match Values"Amazon Warriors"Amazon WarriorsAmazon Warriors 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.

Two Columns

PropertyExample RuleExample ResultMeaning
Field Names"Company Name|City"Company Name|CityCompany Name and City will be used as the Fields for each column to match values against.
Match Values"Amazon Warriors|Munich"Amazon Warriors|MunichAmazon Warriors based in Munich will be looked for in the Calculation Table in their corresponding columns. Matching rows will be deleted.
Table Name"Customers"CustomersCustomers is the name of the Calculation Table to delete these rows from.

Example Results

One Column

IDCompany NameCityCountry
3Super JetsTrevisoItaly
4Super LeagueLeedsEngland
5Super LeagueGranadaSpain

The Output results for the example would be:

Output NameOutput Value
Deleted Rows Count2

Two Columns

IDCompany NameCityCountry
1Amazon WarriorsStrasbourgFrance
3Super JetsTrevisoItaly
4Super LeagueLeedsEngland
5Super LeagueGranadaSpain

The Output results for the example would be:

Output NameOutput Value
Deleted Rows Count1

See Also

Calculation Tables

Export To Calculation Table