How to remove duplicate

[#1]

Hi

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

The attachment is the sample data...

Thanks..

[preminqlik]

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);

[#3]

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?

[preminqlik]

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