topic Re: MySQL Input & Foreach Loops in Talend Studio

MySQL Input & Foreach Loops

_AnonymousUser — Sat, 16 Nov 2024 12:52:23 GMT

Hi,
I am very new to Talend so please forgive my lack of knowledge. Im sure theres a simple solution to my issue which is as follows.

As you can see in the image above, I have a foreach loop which is looping through 7 values, before looping through a selection of rows from the 'times' table (based on the first foreach current value), which is then getting looped further by another foreach with 4 values. Basically what I need, and what I am struggling to get working, is to be able to map the both current foreach values and some from the 'times' table current row into the new mySQL output in the 'time' table. I have tried to use the iterateToFlow component with limited success so I am really out of ideas now.
I hope I have explained this clear enough and hopefully someone out there can help.
Any repsonse would be much appreciated.
Thanks in advance.

Re: MySQL Input & Foreach Loops

_AnonymousUser — Fri, 10 Jun 2011 09:57:24 GMT

The image obviously didnt upload properly. Heres the direct link.
Thanks
Talend Screenshot

Re: MySQL Input & Foreach Loops

_AnonymousUser — Fri, 10 Jun 2011 09:58:08 GMT

http://img200.imagevenue.com/img.php?image=693691181_ss_122_127lo.jpg

Re: MySQL Input & Foreach Loops

Anonymous — Fri, 10 Jun 2011 13:53:06 GMT

Here's a clickable thumbnail to the larger picture. We have a URL restriction policy for members under 10 posts.
Thanks for your post.
Best,
Pcoffre.

Re: MySQL Input & Foreach Loops

alevy — Sun, 12 Jun 2011 03:51:29 GMT

I think you need to have a tFlowToIterate component between your tMysqlInput component and your tForEach_2 component. That will allow you to place the values read from the times table onto the globalMap whence they can be retrieved in your tIterateToFlow component.

Re: MySQL Input & Foreach Loops

_AnonymousUser — Mon, 13 Jun 2011 11:13:58 GMT

Thanks that did the job. Much appreciated.