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

Delete Simple Table Rows

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

Properties

Property NameDescriptionExample
Field NamesThe column names to match against, delimited by pipe bars "|"."Country"
Match ValuesThe values to match against based on the fields specified in the 'Filed Names' property. Values should be delimited by pipe bars "|"."Germany"
Table NameThe name of the Simple Table to remove rows from.Customers
TitleChanges the Title (not the name) of the task.Delete Simple Table Rows

Example Data

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

DriveWorks Tech Tips Portal

Copy Table

Shows how you can copy data from one Simple Table to another, remove selected rows and clear the whole table using macros.

View all Tech Tips

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.

View all Tech Tips

DriveWorks Tech Tips Portal is available to DriveWorks Pro customers with an active subscription and support contract.

Tech Tips provide cut down projects that highlight specific functionality for faster and more effective learning.

To access the portal:

  1. Go to https://hub.driveworks.co.uk/tech-tips/
  2. Login with your DriveWorks Pro account credentials, if asked
  3. Click the Visit Tech Tips Portal button for access

The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require.

Table of Contents