topic Re: simple tLoop? modify data on each iteration in Talend Studio

simple tLoop? modify data on each iteration

mmoye — Tue, 29 Jan 2019 19:32:41 GMT

Hello,

I am very new to Talend and trying to figure out tLoop. I am using tMap to simply transfer data from one postgresql table to another:

I would like to be able to do the following. For every row in the input, i would like to insert four records in the output with just one field from the input. However, I would like to modify the data slightly for each.

So for example from above I have uuid in row2 table. On the right in output I want that one uuid to be repeated 4 times but with the following modification:

iteration input output ("role" field)

1 uuid uuid (as mapped in graphic above)

2 uuid uuid + "_a"

3 uuid uuid + "_b"

4 uuid uuid + "_c"

The output would only be for the "role" output field as seen above. The description field remains the same for each iteration (just uuid).

How can i achieve this? Seems like it would be really simple but it is stumping me.

Thank you for any assistance!

Re: simple tLoop? modify data on each iteration

akumar2301 — Tue, 29 Jan 2019 22:31:04 GMT

Create a loopkup file with string needed with four line ( 1st line space)

_a
_b
_c

and in tmap logic as mentioned below

let me know if it works.

Re: simple tLoop? modify data on each iteration

mmoye — Tue, 29 Jan 2019 22:42:41 GMT

Sorry, like I said I'm really new to Talend. How is tFixedFlowInput used?

Re: simple tLoop? modify data on each iteration

akumar2301 — Tue, 29 Jan 2019 22:50:01 GMT

Screenshot for lookup ( you can use any input file as well)

2nd tfixedinput would be you tDBinput component main flow.

Re: simple tLoop? modify data on each iteration

mmoye — Tue, 29 Jan 2019 22:57:51 GMT

Brilliant, and I never would have come across it. Thank you so much!