Home Search

DriveWorks Pro 22
TableMax

Send Feedback

TableMax

Gets the row containing the maximum of the values in a column of the given table.

Syntax

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.

Examples

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"}

Sample Data Table

Items Table

ItemWidthPositionCost
Single Drawer Unit600Rear Wall330
Double Drawer Unit900Rear Wall495
Single Cupboard Full600Rear Wall280
Double Cupboard Full900Rear Wall440
Single Cupboard with Drawer600Left Wall300
Double Cupboard with Drawer1200Left Wall600
Cupboard Left Drawer Right1200Left Wall610
Cupboard Right Drawer Left1200Left Wall610
Single Cupboard with Drawer600Right Wall300
Double Cupboard with Drawer1200Right Wall600
Cupboard Left Drawer Right1200Right Wall610
Cupboard Right Drawer Left1200Right Wall610

DriveWorks Tech Tips Portal

Table Functions

A selection of available functionality when pulling data from a DriveWorks Table onto your form.

View all Tech Tips

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:

  1. Go to https://my.driveworks.co.uk/learn/tech-tips/
  2. Login with your DriveWorks Pro account credentials, if asked
  3. Click the Visit Tech Tips Portal button for access

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

How To: Work With Arrays