Discussions

Expand all | Collapse all

Delete Unmatched Records After Mass Upload

  • 1.  Delete Unmatched Records After Mass Upload

    Silver
    Contributor
    Posted 01-22-2018 05:54
    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. 


  • 2.  RE: Delete Unmatched Records After Mass Upload

    Top
    Contributor
    Posted 01-22-2018 06:44
    Just delete those records where the [Date Modified] is older than the date of the previous mass update.


  • 3.  RE: Delete Unmatched Records After Mass Upload

    Silver
    Contributor
    Posted 01-22-2018 20:23
    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.