DriveWorks Solo 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(DWLookupCustomers,1,"D*")Will filter the 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"}


Table of Contents