What is the use of Distinct?

[Anonymous]

Example:

Tab1:

Load ID,Name, Dept

from a.xls;

Tab2:

Load disntict ID, Name, Dept

from a.xls;

Both brings the same result. What is the use of distinct keyword?

[sushil353]

Distinct keyword will eliminate the duplicate records...

do u have duplicate id's in your database?

HTH

Sushil

[Anonymous]

Yes , i have duplicate values to ID column.

[#4]

Hi,

If  you use disinct load then  duplicate records are eliminated. If you have duplicates in combination of

ID,Name, Dept then qlikview will eliminate the duplicate records without using distinct.