Eliminates non-matching values from the table.
TableFilterAll([Table or Table Name], [Condition], [Ignore Whitespace])
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.
Ignore Whitespace (optional) is True to ignore leading/trailing whitespace characters in text strings in the condition, otherwise False.
| Rule | Meaning |
|---|---|
| TableFilterAll(DwLookupCustomers,DWLookupFilterList, True) | Will return an array filtered to display all values from the Customers table that match the conditions given in the table FilterList. Will ignore any leading or trailing whitespace in the given condition table. |
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 |
| 1 | B* |
|---|---|
| 3 | G* |
This is the list of operators that are available to apply to the Condition argument.
| Name of Operator | Operator | Example Condition Argument |
|---|---|---|
| Less then | < | "<900" |
| Less then or Equal to | <= | "<=900" |
| Greater then | > | ">900" |
| Greater then or Equal to | >= | ">=900" |
| Not Equals | <> | "<>=900" |
| Equals | = (No Symbol Required) | "900" |
| Like | "*" | "*Single*" |
| Not Like | "<>*" | "<>*Single*" |
| 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"} |