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
2 REPLIES
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