Count Distinct Values
Returns how many unique values a list contains. Use it to count distinct items, for example the number of different products or order numbers in a list.
Returns how many unique values a list contains. Use it to count distinct items, for example the number of different products or order numbers in a list.
What it does
- Counts the distinct (unique) values in the provided list, ignoring duplicates.
Inputs
| Name | Type | Required | Description |
|---|---|---|---|
| List | List | - | input list |
Outputs
| Name | Type | Description |
|---|---|---|
| Count | Number | distinct count |
Notes
- Duplicates are counted only once, so a list of [A, A, B] returns 2.