Lists distinct values from a table’s column.
ListAllDistinct([Table], [Column])
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.
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. |
Table | Column | Outcome |
|---|---|---|
| Vehicles | 1 | "Volkswagen|Ford|Renault|Mazda" |
| Vehicles | 3 | "Blue|Red|White|Silver|Black" |
Vehicles Table
| Make | Model | Color | Mileage |
|---|---|---|---|
| Volkswagen | Golf | Blue | 40000 |
| Ford | Escort | Red | 55000 |
| Renault | Kangoo | White | 37000 |
| Ford | Mondeo | Red | 28000 |
| Mazda | 2 | Red | 82000 |
| Volkswagen | Golf | Silver | 110000 |
| Volkswagen | Polo | Blue | 72000 |
| Ford | Mondeo | Red | 54000 |
| Renault | Laguna | Black | 46000 |