Eliminates non-matching values from the table.
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.
Rule | Meaning |
---|---|
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. |
Customers Table
CustomerName | City | Country |
---|---|---|
Amazon Warriors | Paris | France |
Bolton Burners | Concord | United States |
Boston Bulls | Hanover | Germany |
Cambridge Cats | Toulouse | France |
Dynamo Dynamics | Indiana | United States |
Eagle Sizzlers | Maine | United States |
Everso Lucky | Vermont | United States |
Forty Somethings | Illinois | United States |
FilterList Table
1 | B* |
---|---|
3 | G* |
CustomerName | City | Country |
---|---|---|
Boston Bulls | Hanover | Germany |
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"} |