Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
anson_kong
Contributor II
Contributor II

Remove the first record in load script

hi all,

I have the many excel from the supplier.

the excel stores the date, date time and ID for each day.

however , the ID may exists again in next day for revised record.

I would like to delete the first record and keep the latest one.

example.

excel file namedatedatetimeidlocation
17Jan04.xls2017-1-42017-1-4 12:30ID00123HA
17Jan05.xls2017-1-42017-1-4 12:30ID00123KL

how can do it in load statement?

thank you

11 Replies
avinashelite

Try like this :

Master:

LOAD

[excel file name],

date,

datetime,

id,

location

from

table

Right join

LOAD

max(datetime) as datetime,

id

resident

Master

Group by

id;

anson_kong
Contributor II
Contributor II
Author

beautiful,

thank you avinashelite