simple tLoop? modify data on each iteration

[mmoye]

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!

[akumar2301]

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.

[mmoye]

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

[akumar2301 · Accepted solution]

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

2nd tfixedinput would be you tDBinput component main flow.

[mmoye]

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