I import data into a table, and one of the fields is a booking number, which is unique.
How can I make this field unique, that the import doesn't import the same ID including all the other data several times?
Thank you,
+16Hi there!
The CSV import extension will allow you to merge data from your import file to existing records in your base in order to prevent duplicate entries. However, if your file has duplicate entries within it (for example, five rows all with the same booking number), this will not be recognized via the merge feature as it only looks to records within your base to match against. To get around this, feel free to import the data and then use the dedupe extension to find and merge the duplicate records.
Hope this helps point you in the right direction!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.