Help please!!! Only last global variable being passed with tflowtoiterate

[rwnetwork]

Hi Community,

I'm stuck!! I have a .txt file as my input and I only need a query down the line (blue) to use 8 products that are passing in a tflowtoiterate (as you can see in photo). However, the last product on the console, RELSAV, is the ONLY product being passed to my query and then to my output.  The query being used to call the 8 products is as follows:

select X

from XYZ

where fdtype in '" + globalMap.get("fitype") + "'

I don't know what I need to do in order to get those 8 to be recognized in my query.  I've tried so many different ways and just going in circles.

Please any help!!
Michelle

[TRF]

This answer may help you https://community.talend.com/t5/Design-and-Development/How-to-use-IN-keyword-in-tSalesforceInput/m-p...

[Anonymous]

Hi,

Have you checked the 'append' checkbox on your tFileOutputDelimited component?

[manodwhb · Accepted solution]

@mmiller32 , are you getting 8 product to tFlowtoIterate? and one more thing 

globalMap.get("fitype")  should be globalMap.get("row2.fitype") ,since the Main row name is row2 to tFlowtoIterate.

[rwnetwork]

Oh gosh, I never saw this, thank you very much for responding.  Our project was put on hold and I just returned back to this, so will advise if your notes helped.

Thanks!