dynamically lookup columns

Five Stars

dynamically lookup columns

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
Moderator

Re: dynamically lookup columns

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: dynamically lookup columns

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch