Lookup transformation


Could we have the possibility to have matching over several columns for the lookup transformation ?



You can use the “Merge another table” action to do a lookup matching over several columns. In the options of this action, you choose which columns should match in each table, and then choose which column (or columns) you want to retrieve in the case all columns match. I attach a sample project below.

Here is a screenshot:

Sample project: Lookup matching over several columns.morph (3.5 KB)

Hope this helps!


1 Like

I such a case, the merge transformation implies 3 steps instead of 1 with a lookup transformation over several column for the matching.

RegardsLookup matching over several columns 2.morph (4.3 KB)