Skip to main content
Question

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

  • February 1, 2018
  • 0 replies
  • 93 views
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.

    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.
    Terms & ConditionsAccessibility statement