topic Re: Copy input to multiple rows in Talend Studio

Copy input to multiple rows

Anonymous — Wed, 29 Nov 2017 12:05:55 GMT

Hi,

I need to create n multiple output rows for an input row depending on a field in the input row. I tried with tJavaFlex but failed. The iteration is to limited due to the fact that I need variable iterations based on the input, see example below. After the duplication each row's fields will be changed (field Account). Any clue how I could achieve this? Thanks

Example

Re: Copy input to multiple rows

Anonymous — Wed, 29 Nov 2017 15:37:22 GMT

I'm afraid your example data doesn't show how or why the rows are multiplied. However, so long as you understand this, you can use this tutorial to carry this out (https://www.rilhia.com/quicktips/quick-tip-row-multiplication). You will first need to understand a rule for multiplying each row, once you have that, just convert it into some simple Java mechanism and use it with the example.

Re: Copy input to multiple rows

Anonymous — Wed, 29 Nov 2017 16:25:12 GMT

Thanks for your reply.

The rule for how many rows I need to create depends on the account in the input. I wanted to do something like

if account = A then create row with account A1 and create row with account A2

if account = B then create row with account B1

if account = C ... t

Re: Copy input to multiple rows

Anonymous — Wed, 29 Nov 2017 17:32:31 GMT

OK, that is entirely possible using the tutorial I gave you. You will need to look at the looping logic in the tJavaFlex and implement it there.