Delete Unmatched Records After Mass Upload

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
I need a native solution if I may.  We have a warehousing system and we receive an Excel extract  periodically which we upload to a stand alone table.  Serial number is the key field. As some of the records we uploaded fall off the list, the question is how do we identify such records which are not matching the records in the latest upload and delete these. 
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 28,304 Points 20k badge 2x thumb
Just delete those records where the [Date Modified] is older than the date of the previous mass update.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,142 Points 3k badge 2x thumb
Thanks. As this table has separate uploads for different suppliers, this test may not work for all. This should work. But using your insight, I have added field to place a check where no update is made to distinguish records.  Many thanks for your help.