topic dynamically lookup columns in Talend Studio

dynamically lookup columns

Anonymous — Tue, 07 Jul 2015 13:03:51 GMT

Hi,
I have one main table and one lookup table.need to lookup 3 to 4 columns in lookup table.
But, columns which we need to lookup should be dynamic. i mean, howmany columns or which columns need to lookup should be configured.
Is there any way to do this?
Please post me info regarding this
Thanks,
Jaya

Re: dynamically lookup columns

Anonymous — Thu, 09 Jul 2015 04:47:29 GMT

Hi,
Are you using Dynamic Schema in your input source?

columns which we need to lookup should be dynamic. i mean, howmany columns or which columns need to lookup should be configured.

Could you please set an example for us?
Best regards
Sabrina

Re: dynamically lookup columns

Anonymous — Thu, 09 Jul 2015 09:33:29 GMT

Hi,
i have two tables: invoice and customer
invoice table:
invoice_number,customer_num,company_code,branch
customer:
customer_num,company_code,branch
first i got requirement like , i need to lookup customer_num,company_code,branch (inner join) in customer table and get invoice_number
invoice---------------->tmap ===> invoice_num
customer.|
after that i got another requirement like lookup only comapny_code and customer_number.
after that i got like lookup only customer_number.
i want to use only one job for above 3 different requirements in such a way that we can configure columns?
Thanks in advance
Jaya