About Import Types

There are three methods for importing data to your lookup tables: merge, delete, and insert. Each method combines new data with existing data in a different way.
Importing Lookup Table Data with Merge

When you import data using the merge method, new records are added to your lookup table. Existing records whose Unique Identifier (as defined in the configuration of the lookup table) matches the unique identifier of records in the data file will be overwritten. You can also delete all existing data in the lookup table before importing new data.

Use merge when you want to update records.

Importing Lookup Table Data with Delete

When you import data using the delete method, records are removed from the lookup table.

Existing records whose Unique Identifier (as defined in the configuration of the lookup table) matches the unique identifier of records in the data file will be deleted.

Use Delete when you want to target specific records for deletion from the lookup table.

Importing Lookup Table Data with Insert

When you import data using the insert method, new records are added to the lookup table. If the unique identifier of an existing record matches the identifier of a record in the data file, an error is logged in an error file. The import will continue and valid records will be added to the lookup table. You can also delete all existing data in the lookup table before importing new data.

Use Insert only when you want to add new records.