DriveWorks Pro 22

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]

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.

Examples

Example Data

This is the Customers table that has each occurrence counted.

Example Result When Viewed As A Table