Key Lookup

The Key Lookup dialog is used to define relations between your data and other tables in the database. This is useful if you don't have the id of the items you want to reference, but instead you have the value of one of the other columns.

Consider the examples of locations and countries. The locations table contains a column called country_id that links it to the countries table. Let's assume that in your input file you have the country name of the countries in a column. Then you can use the key lookup to get their id from the countries table. Just define the lookup to use the countries table and the country_name column.

A list of example items from this table will be shown below so you can make sure that you selected the correct combination of table and column.