DriveWorks Pro 23

TableDistinctCount

TableDistinctCount

Creates a table showing distinct values in the first column, and number of occurrences in the second.

Syntax

TableDistinctCount([Table or Table Name],[Column index],[Ignore case],[Include Header Row],[Sort Ascending]

Where:

Table or Table Name is the table to filter.

Column index is the index of the column to group and count.

Ignore case (optional) is TRUE to group entries regardless of case, FALSE to maintain case sensitivity.

Include Header Row (optional) is TRUE to include column headers, FALSE to ignore them.

Sort Ascending (optional) is TRUE to sort the results Ascending, FALSE to sort Descending.

Examples

Example Data

This is the Customers table that has each occurrence counted.

Example 1 Result When Viewed As A Table

Example 2 Result When Viewed As A Table (Count column sorted ascending)