Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
BderPan
Contributor III
Contributor III

Use a row flow as globalMap Var in a tDB Input

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 




Labels (1)
  • v7.x

2 Replies
fdenis
Master
Master

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

Can you share your tFlowToIterate settings + schema?