topic Re: hi in QlikView

hi

Sat, 21 Feb 2015 18:24:25 GMT

How to eliminate duplicate values frm a table while loading?

Re: hi

robert_mika — Sat, 21 Feb 2015 18:30:12 GMT

Try:

LOAD DISTINCT

ID,

Sales

.....

Re: hi

mustafaelryah — Sat, 21 Feb 2015 18:35:36 GMT

Hello ,

Find the solution here

How to get real distinct value.

Looking forward.

Re: hi

Anonymous — Sat, 21 Feb 2015 18:39:22 GMT

Hi,

Try:

Load Distinct Field1,Field2 from ABC;

Regards

Neetha

Re: hi

Sat, 21 Feb 2015 19:10:12 GMT

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.

Re: hi

Sat, 21 Feb 2015 19:40:00 GMT

Hi,

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

Regards

Nandkishor S Pandirkar

Re: hi

robert_mika — Sat, 21 Feb 2015 20:57:01 GMT

Unless you have your Region data not cleaned

' East'

' East '

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