distinct function?

[#1]

what is work of  distinct  function?

whether it wont allow duplicate values are ?

[alexandros17]

In load or Select or aggregations, Distinct predicate discards duplicate values (of the specified fields)

[#3]

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

[#4]

It will not allow duplicate values

[fkeuroglian]

see this

hope helps

What is the use of Distinct?

What is the use of Distinct?