Home Search

DriveWorks Pro 22
ListAllConditionalDistinct

Send Feedback

ListAllConditionalDistinct

Lists distinct values from a table’s column, where specified conditions are met for each row.

Syntax

ListAllConditionalDistinct([Table], [Column] , [ConditionColumn1] ,[Condition1])

Where:

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.

ConditionColumn is the number of the column within the table to filter the data on.

Condition is an expression that when met will include the data from the column.

Multiple Conditions are separated by a comma and must start with the column number followed by the condition, as below:

[ConditionColumn1] , [Condition1] , [ConditionColumn2] , [Condition2]

There is no limit to the number of ConditionColumn and Condition arguments, although they do need to be used in pairs.

Examples

Rule

Meaning
ListAllConditionalDistinct(Vehicles,1,3,"Red")

Or

ListAllConditionalDistinct(Vehicles,1,3,"=Red")

The function looks in the Vehicles table, and retrieves all the data in the first column, where the third column equals red. In this case, that first column contains car makes, so the list;

"Ford|Mazda" is returned.

ListAllConditionalDistinct(Vehicles,2,4,"<60000",3,"=Red")The function looks in the Vehicles table, and retrieves all the data in the second column, where the fourth column is less than 60000 miles and the third column equals red. In this case, that second column contains car models, so the list;

"Escort|Mondeo" is returned.

ListAllConditionalDistinct(Vehicles, 1,3,"=" &ColorReturn)The function looks in the Vehicles table, and retrieves all the data in the first column where the data in column 3 equals the value selected from the Color form control. In this case, that first column contains car makes, so the list;

"Ford|Mazda" is returned.

Example Outcomes

Table

Column

ConditionColumn1

Condition1

ConditionColumn2

Condition1

Outcome

Vehicles13"=Red""Ford|Mazda"
Vehicles24"<60000"3"=Red""Escort|Mondeo"

Example Data

Vehicles Table

MakeModelColourMileage
VolkswagenGolfBlue40000
FordEscortRed55000
RenaultKangooWhite37000
FordMondeoRed28000
Mazda2Red82000
VolkswagenGolfSilver110000
VolkswagenPoloBlue72000
FordMondeoRed54000
RenaultLagunaBlack46000