This content has been marked as final. Show 11 replies
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.
|excel file name||date||datetime||id||location|
how can do it in load statement?