topic Re: "Join" using sql query with parameters in Talend Studio

"Join" using sql query with parameters

Anonymous — Wed, 13 Mar 2019 10:02:16 GMT

Hello community !

I am doing a sql query on the tDbInput as shown in the picture, then I want to use both columns as parameters for the component 2 request (tDbROW).

The FileName works but for the comparison of the count it does not work

Anonymous — Wed, 13 Mar 2019 10:02:44 GMT

THE RESULT :

6.PNG

fdenis — Wed, 13 Mar 2019 10:45:11 GMT

you have to use

where fileName='" + row1.FileName + "'

but it's not the best way.
I'll rather to add tMap to join results from booth queries.