DriveWorks Pro 15: ListAllDistinct [send feedback...]

LISTALLDISTINCT

Lists distinct values from a table’s column.

Syntax

LISTALLDistinct( [ Table], [ Column] )

The Table is the table from which to retrieve the data.

Column is the number of the column within the table to retrieve the data from.

Examples

Rule

Meaning
LISTALLDISTINCT(Vehicles, 1)The function looks in the Vehicles table, and retrieves all the data in the first column (as specified by the user). In this case, that first column contains car makes, so the list; "Volkswagen|Ford|Renault|Mazda" is returned.

Example Outcomes

Table

Column

Outcome

Vehicles1"Volkswagen|Ford|Renault|Mazda"
Vehicles3"Blue|Red|White|Silver|Black"

Example Data

Vehicles Table

MakeModelColourMileage
VolkswagenGolfBlue40000
FordEscortRed55000
RenaultKangooWhite37000
FordMondeoRed28000
Mazda2Red82000
VolkswagenGolfSilver110000
VolkswagenPoloBlue72000
FordMondeoRed54000
RenaultLagunaBlack46000

Table of Contents