To filter 3 different value from different tables from MSSQL database

[Anonymous]

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.

 

Best Regards,Toe Toe

[aashish_21nov]

Hi @ToeToeAung

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