If a pipeline has been configured appropriately and the data loader has edit rights on the relevant data tables, the data loading Issues tab gives the data loader the ability to resolve failed lookups in an interactive manner by either creating synonms or by adding new rows to reference data tables. This can happen during data loading (preview mode) or after data loading (committed batch).

For example, in the issue below “South Sudans”, with an extra “s” at the end, was not found in the REF_COUNTRY table.

Add synonym

It is possible to add “South Sudans” as a synonym. If the user has edit rights on REF_COUNTRY (the lookup table), it is also possible to add “South Sudans” as a new country record (but that would be the wrong choice in this case).

The right choice in this case is to “Add South Sudans as synonym”. A second dropdown displays a list of records from REF_COUNTRY table. The user is choosing which country “South Sudans” should map to. Then press the “+” button.

The “+” button opens up the data edit form for the REF_SYNONYMS table, initialized to the previously selected values (if the synonym table has more than 2 fields, they can be edited at this time).

Pressing the Submit button commits the new REF_SYNONYMS record to the database. Upon returning to the previous screen, visual confirmation that the synonym has been committed should appear (a temporary “Data Saved” message).

Note that you can navigate to either the synonym table (or the ref data table) in a new browser tab by pressing the grid icon:

Add ref data

On the other hand, if you determine that “South Sudans” should be a new country in the REF_COUNTRY table, pressing the “+” button would open up a data edit form for REF_COUNTRY and initialize the lookup field (NAME_SHORT_EN) with “South Sudans”.

Reprocess batch

After adding synonyms or new reference data records, the batch needs to be reprocessed in order to apply the changes to the data being loaded.