<< Click to Display Table of Contents >> ETL > 14.0 u1 > Implementation Guide > Tutorial and implementation guide > Steps > Enriching  Look-up keys

The value of key parameter is the name of the column used for look-up. If you provide it as a string, it is assumed the column has the same name in both main table and the table being used for look-ups. If the columns have different names, use the following syntax:

{

    "in": "Car",

    "key": {

        "primary": "CarRegistrationId",

        "foreign": "CarRegistration_FK"

    },

    "take": "Address"

}

 

Where the value for primary property is the name of the column in the main table (enriched table), and the value of the foreign property is the equivalent column in the table used as a look-up table.