2 Replies Latest reply on Jan 7, 2020 6:20 AM by David Lopez Cruz

    File Reader with Same Date

    SP K Active Member

      Hi Team,

       

      I have a scenarios, I have to read a file daily " File_Name_date.txt " load to Table. Same Date file may come multiple time in a day so If the same Date file process again then i need to Delete all the records with the file date and insert the all the records in file to table.

       

      I tried with Mapping variable to set with File date and tried with Pre SQL delete statement but it is deleting all the records processed before day.

       

      Please help

       

      Thanks

      pk