Forum Discussion

RubyKapil2's avatar
RubyKapil2
Qrew Captain
8 years ago

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 s...
App builders
Ask about Quickbase functionality
Data import and export
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
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.
KatherineOlson's avatar
KatherineOlson
Qrew Member
6 years ago
Can someone expand on this suggestion?

1. How would I detect duplicates using a relationship between the table and a scratch table?
2. Assuming a "table to table copy" is a "table to table import," how do I get only the unique records to copy?
3. Lastly, how do I get that import into a URL button?

------------------------------
Katherine Olson
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    Can you explain what you mean by Duplicates?  Do you mean a duplicate of the Key field in the target table?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------