Skip to main content
Question

Delete Unmatched Records After Mass Upload

  • January 22, 2018
  • 0 replies
  • 31 views
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. 
      This topic has been closed for replies.

      • anomDiebolt
      • Registered
      • January 22, 2018
      Just delete those records where the [Date Modified] is older than the date of the previous mass update.
      • ArshadKhwaja
      • Author
      • Registered
      • January 23, 2018
      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.
      Terms & ConditionsAccessibility statement