topic Re: Help please!!! Only last global variable being passed with tflowtoiterate in Talend Studio

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

rwnetwork — Tue, 03 Mar 2020 14:53:27 GMT

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

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

TRF — Tue, 03 Mar 2020 15:36:24 GMT

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

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

Anonymous — Tue, 03 Mar 2020 21:54:32 GMT

Hi,

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

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

manodwhb — Thu, 05 Mar 2020 04:14:24 GMT

@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.

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

rwnetwork — Tue, 24 Mar 2020 14:56:27 GMT

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!