To filter 3 different value from different tables from MSSQL database

Four Stars

To filter 3 different value from different tables from MSSQL database

Hi Talend Team,

 

The below is my job flow in talend. In tJavaRow_2, I have set value from excel file to the contex variable. Upon that value, it will filter the data from tMSSqlInpur_1 and map in TMap. The problem is, I have two other values to filter from table from DB and wish to map in tMap.  I tried to add two more tMSSqlInput and map it to tMap. It is not working. Please help me out. Thank you in advance.

 talend.png

 

Best Regards,Toe Toe

Seven Stars

Re: To filter 3 different value from different tables from MSSQL database

Hi @ToeToeAung

 

Really appreciate your efforts, but you can directly use the context variable value in your query itself.

Regards
Aashish
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.