Returns a datatable with a single column, containing all the distinct values in the column.

Syntax

Smartsite SXML CopyCode image Copy Code
datatable datatable.distinct(datatable dataTable, string columnName)

Parameters

Name Data Type Description
dataTable DataTable The datatable in which this viper will search for distinct values.
columnName String The name of the column in which this viper will collect all dinstinct values.

Return Value

Data Type Description
DataTable Returns a datatable with all dinstinct values found in the specified column of the datatable.

Expand image Example

SXML