Gets the row containing the maximum of the values in a column of the given table.
TableMax([Table], [Column Index])
Where:
Table is the table that is to be filtered.
Column Index is the column number the Condition is to be applied to.
Rule | Meaning |
|---|---|
| TableMax(DwLookupItems,4) | Gets the first row to be found with the largest value in column 4 (Cost), of the Items table (below). Will result in: {"Cupboard Left Drawer Right","1200","Left 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 |
DriveWorks Tech Tips Portal |
Table Functions A selection of available functionality when pulling data from a DriveWorks Table onto your form. |
DriveWorks Tech Tips Portal is available to DriveWorks Pro customers with an active subscription and support contract. Tech Tips provide cut down projects that highlight specific functionality for faster and more effective learning. To access the portal:
The portal provides a search facility, start typing the name of the Tech Tip (as indicated above) to display the Tip you require. |
See also