<< Click to Display Table of Contents >> ETL > 14.0 > Implementation Guide > Tutorial and implementation guide > Steps > Enriching  Consolidating look-up targets

If all your tables have the same look-up column and key, you can use an array for the value of in parameter. For example, the following two statements are equal:

"lookup": [

    {

        "in": "Cars1",

        "key": "CarRegistration",

        "take": "Address"

    },                

    {

        "in": "Cars2",

        "key": "CarRegistration",

        "take": "Address"

    }

]

 
Is equal to the following (consolidated in property):

 

"lookup": [

    {

        "in": ["Cars1", "Cars2"],

        "key": "CarRegistration",

        "take": "Address"

    }              
]

 

The priority of lookups is then defined by the order in which they appear in the in statement.