Seven Stars

tMap reuse 1 Lookup in same tMap

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  

  

Tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Twelve Stars TRF
Twelve Stars

Re: tMap reuse 1 Lookup in same tMap

Hi,

 

Case not clear in my opinion.

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


TRF
3 REPLIES
Twelve Stars TRF
Twelve Stars

Re: tMap reuse 1 Lookup in same tMap

Hi,

 

Case not clear in my opinion.

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


TRF
Seven Stars

Re: tMap reuse 1 Lookup in same tMap

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?

Twelve Stars TRF
Twelve Stars

Re: tMap reuse 1 Lookup in same tMap

No, as files are for input only.


TRF