Home Search

DriveWorks Solo 18
TableFilterAll

Send Feedback

TableFilterAll

Eliminates non-matching values from the table.

Syntax

TableFilterAll(Table or Table Name As Table, Condition As Table)

Where:

Table or Table Name is the Table to filter.

Condition is the name of a table containing conditions. The table should not have a header row. Each row should have 2 columns where the first is the column index number to check and the second column is the condition to filter on.

Examples

RuleMeaning
TableFilterAll(DWGroupTableCustomers,DWLookupFilterList)Will return an array filtered to display all values from the Customers group table that match the conditions given in the table FilterList.

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

FilterList Table

1B*
3G*

Example Outcome

CustomerNameCityCountry
Boston BullsHanoverGermany

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

Table returned as an Array
{"CustomerName","City","Country";"Boston Bulls","Hanover","Germany"}