DriveWorks Pro 15: TableFilter [send feedback...]

TableFilter

Eliminates non-matching values from the table.

Syntax

TableFilter(Table or Table Name As Table, Column Index 1 As Double, Condition 1 As String, Column Index 2 As Double, Condition 2 As String, Column Index 3 As Double, Condition 3 As String)

Where:

Table or Table Name is the Table to filter.

Column Index 1 is the first column to filter on.

Condition 1 is the condition to filter column 1 on.

Column Index 2 (optional) is the second column to filter on.

Condition 2 (optional) is the condition to filter column 2 on.

Column Index 3 (optional) is the third column to filter on.

Condition 3 (optional) is the condition to filter column 3 on.

Examples

RuleMeaning
TableFilter(DWGroupTableCustomers,1,"D*")Will filter the Group Table Customers to return an array containing only the rows whose value in column 1 begins with D.

Example Data

Customers Table

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton BurnersConcordUnited States
Boston BullsHanoverGermany
Cambridge CatsToulouseFrance
Dynamo DynamicsIndianaUnited States
Eagle SizzlersMaineUnited States
Everso LuckyVermontUnited States
Forty SomethingsIllinoisUnited States

Example Outcome

CustomerNameCityCountry
Dynamo DynamicsIndianaUnited States

DriveWorks will return the table above as an array, which will look like:

Table returned as an Array
{"CustomerName","City","Country";"Dynamo Dynamics","Indiana","United States"}

DriveWorks Tech Tips Portal

Table Filtering

The TableFilter function allows a Data Table to be filtered using other form controls (such as a text box or combo box) so that only the relevant items are displayed.

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