Hi Talend Users,
Is it possible to reuse the same lookup source in 1 tMap? I have a number of columns I want to convert using a lookup table. Each column contains the primary key for the lookup table but can I configure 1 tMap to convert all the columns in 1 go or do I need to position the 2 or more tMaps in serial
Most examples I have seen seem to handle the case where you want 2 or more columns as keys to return 1 value from the lookup table
Example input table
ID as int Product1 as string Product2 as string
Example Lookup Table
ProductID as string ProductPrice as int
Desired Output Table
ID as int Product1 as string Product1Price as int Product2 as string Product2Price as int
Solved! Go to Solution.
Coming back to this could I use a tReplicate to generate multiple lookup flows for the same tMap from 1 source or does the tMap only accept 1 flow from the same component?