Discussion board where members can get started with Qlik Sense.
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.
how can do it in load statement?
Go to Solution.
Try like this :
[excel file name],
max(datetime) as datetime,
you kann use 2. load statement
with lastvalue() or firstvalue()
in the 2. loadscript
with Group and sort Statements
load ID , // YTRAUF.LHMNR & max(#DATUM)as %LASTKEY, LastValue([excel file name]) as #LAST_Filename resident EXCEL group by ID order by ID ,[excel file Name];
thank you gerry_hdm
although it can find out the last value, synthetic key is created and cannot remove the first value.
try may be
Could you share the sample app/script ?
I would like to have the below result, thank you all
Kong, in your example jan 5 will be latest rite ? I didn't get how your identifying the Jan 4th as the latest
drop the table or rename the Variable
from your synthetic key
or sending a example in the Forum
try this with your data
load * from table order by fieldx desc;
Yes, thank you