Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
what is work of distinct function?
whether it wont allow duplicate values are ?
In load or Select or aggregations, Distinct predicate discards duplicate values (of the specified fields)
Distinct will return the distinct values.
For example, if you have a field with three values:
Field:
A
A
B
count(field) will return 3 because you have 3 values in field
count(distinct field) will return 2 because A will be counted as 1
It will not allow duplicate values