tMap reuse 1 Lookup in same tMap

[mobmsc2]

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  

[TRF · Accepted solution]

Hi,

Case not clear in my opinion.

However, you have as many lookups as you want for the same tMap, limit is the lisibility.

[mobmsc2]

If i have 2 lookup inputs to the same lookup file is there a danger of file locks or other issues when running the job?

[TRF]

No, as files are for input only.

[mobmsc2]

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?