topic Re: How to remove duplicate in QlikView

How to remove duplicate

Fri, 25 Apr 2014 02:47:43 GMT

Hi

How could I remove the duplicate when I load the data?

The attachment is the sample data...

Thanks..

Re: How to remove duplicate

preminqlik — Fri, 25 Apr 2014 02:56:52 GMT

hi try this

LOAD Yearmonth,

max([Percent of pass]) as [Percent],

Grade group by Yearmonth,Grade;

Load *

FROM

C:\Users\Piyush\Desktop\SampleData.xlsx

(ooxml, embedded labels, table is Sheet1);

Re: How to remove duplicate

Fri, 25 Apr 2014 03:17:25 GMT

Hi

I think it could be work. But I am not sure that if I have more than 10 fields, the method could work normally?

Re: How to remove duplicate

preminqlik — Fri, 25 Apr 2014 03:36:56 GMT

yes it works

add the below line to above prceding load

max(No) as No

FINAL:

LOAD Yearmonth,

max([Percent of pass]) as [Percent],

max(No) as No,

Grade group by Yearmonth,Grade;

Load *

FROM

C:\Users\Piyush\Desktop\SampleData.xlsx

(ooxml, embedded labels, table is Sheet1);

you can also do by firstsortvalue() if you have more fields