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

Announcements
Mastering Change Data Capture: Read Now
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?