11 Replies Latest reply: Mar 21, 2018 3:56 AM by kong ch RSS

    Remove the first record in load script

    kong ch

      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.





      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