topic Use a row flow as globalMap Var in a tDB Input in Talend Studio

Use a row flow as globalMap Var in a tDB Input

BderPan — Tue, 11 Sep 2018 09:54:19 GMT

Hi,

my Job looks like
tDBInput_ --row9-->tFlowToIterate--Iterate-->tDBInput_5--row10-->tLogRow

in tDBInput_5 I use this Statement

SELECT pzn FROM relevantspositionierung.prokasdb where pzn = '"+(String)globalMap.get("row9.pzn")+"'

and the output is Empty.

The Schema of row9 is Column = pzn | Db Column = pzn.

If I start the Job nothing is happend.

Thanks for your help.

greets Chris

Re: Use a row flow as globalMap Var in a tDB Input

fdenis — Tue, 11 Sep 2018 10:08:16 GMT

"SELECT '"+(String)globalMap.get("row9.pzn")+"', pzn FROM relevantspositionierung.prokasdb"
you can try this.
do not forget " at the begin and at the end

Re: Use a row flow as globalMap Var in a tDB Input

TRF — Tue, 11 Sep 2018 10:13:47 GMT

Can you share your tFlowToIterate settings + schema?