Discussions

Expand all | Collapse all

When importing into existing table from Excel/CSV, if duplicate found, do not import duplicate

  • 1.  When importing into existing table from Excel/CSV, if duplicate found, do not import duplicate

    Posted 02-01-2018 18:36
    Instead move the incoming duplicate records to another table for review.
    Background: I set up a Formula-Text field as the Key field (used API). The formula uses List() to combine Lat and Long with space in between. When I add new data, it combines the Lat and Long first and then updates existing records.
    Sometimes I do want to simply update existing, but other times when new records being added, I want QB to alert me of duplicate and put that duplicate somewhere else for later review, and proceed to import for the non-duplicates.


  • 2.  RE: When importing into existing table from Excel/CSV, if duplicate found, do not import duplicate

    Posted 02-01-2018 18:47
    you would need to import to a temporary scratchpad table first.  Then have a relationship between you real table and the scratchpad table to detect of there is a duplicate. 

    Then I would use a saved table to table copy  in a URL button to copy across the non duplicates.