Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How could I remove the duplicate when I load the data?
The attachment is the sample data...
Thanks..
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);
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?
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