Eliminates non-matching values from the table that meet the given condition.
TableFilter( Table, Column Index, Condition )
Where:
Table is the table that is to be filtered.
Column Index is the column number the Condition is to be applied to.
Condition is the search condition that when matched will filter the table.
Rule | Meaning |
|---|---|
| TableFilter(DwLookupItems,2,">900") | Filters the table to show only the values where column 2 (Width), of the Items table (below), is greater than 900. Will result in: {"Item","Width","Position","Cost";"Double Cupboard with Drawer","1200","Left Wall","600";"Cupboard Left Drawer Right","1200","Left Wall","610";"Cupboard Right Drawer Left","1200","Left Wall","610";"Double Cupboard with Drawer","1200","Right Wall","600";"Cupboard Left Drawer Right","1200","Right Wall","610";"Cupboard Right Drawer Left","1200","Right Wall","610"} |
| Item | Width | Position | Cost |
|---|---|---|---|
| Double Cupboard with Drawer | 1200 | Left Wall | 600 |
| Cupboard Left Drawer Right | 1200 | Left Wall | 610 |
| Cupboard Right Drawer Left | 1200 | Left Wall | 610 |
| Double Cupboard with Drawer | 1200 | Right Wall | 600 |
| Cupboard Left Drawer Right | 1200 | Right Wall | 610 |
| Cupboard Right Drawer Left | 1200 | Right Wall | 610 |
Items Table
| Item | Width | Position | Cost |
|---|---|---|---|
| Single Drawer Unit | 600 | Rear Wall | 330 |
| Double Drawer Unit | 900 | Rear Wall | 495 |
| Single Cupboard Full | 600 | Rear Wall | 280 |
| Double Cupboard Full | 900 | Rear Wall | 440 |
| Single Cupboard with Drawer | 600 | Left Wall | 300 |
| Double Cupboard with Drawer | 1200 | Left Wall | 600 |
| Cupboard Left Drawer Right | 1200 | Left Wall | 610 |
| Cupboard Right Drawer Left | 1200 | Left Wall | 610 |
| Single Cupboard with Drawer | 600 | Right Wall | 300 |
| Double Cupboard with Drawer | 1200 | Right Wall | 600 |
| Cupboard Left Drawer Right | 1200 | Right Wall | 610 |
| Cupboard Right Drawer Left | 1200 | Right Wall | 610 |
This is the list of operators that are available to create specific rules for the TableFilter Function.
| Name of Operator | Operator | Example Rule |
|---|---|---|
| Less then | < | TableFilter(DwLookupItems,2,"<900") |
| Less then or Equal to | <= | TableFilter(DwLookupItems,2,"<=900") |
| Greater then | > | TableFilter(DwLookupItems,2,">900") |
| Greater then or Equal to | >= | TableFilter(DwLookupItems,2,">=900") |
| Not Equals | <> | TableFilter(DwLookupItems,2,"<>=900") |
| Equals | = (No Symbol Required) | TableFilter(DwLookupItems,2,"900") |
| Like | "*" | TableFilter(DwLookupItems,1,"*Single*") |
See also