When importing into existing table from Excel/CSV, if duplicate found, do not import duplicate
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.
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.
