hi

[#1]

How to eliminate duplicate values frm a table while loading?

[robert_mika]

Try:

LOAD DISTINCT

ID,

Sales

.....

[mustafaelryah]

Hello ,

     Find the solution here

How to get real distinct value.

Looking forward.

[Anonymous]

Hi,

Try:

     Load Distinct Field1,Field2 from ABC;

Regards

Neetha

[#5]

this is my table and i loaded the table

sales:

LOAD Region,

     Year,

      Products,

     Sales

FROM

(biff, embedded labels, table is Sheet1$);

in above table i have west and east in field Region so many times...

But i need only one west and east respective data with out duplicates.

how should i apply distinct....

(please ignore if any grammatical mistakes)..

Thanks,

Ramana.

[#6]

Hi,

Can you explain your requirement with sample data or QVW file.

Regards

Nandkishor S Pandirkar

[robert_mika]

Unless you have your Region data not cleaned

like

'  East'

'  East   '

Remember that 'east' and "East" are not the same values in Qlikview.