
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 12, 2023 11:02 AM
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,
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 23, 2023 12:57 PM
Hi 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!
