topic Re: [resolved] Generating multiple rows based on the input in Talend Studio

[resolved] Generating multiple rows based on the input

ahsin — Thu, 01 Sep 2016 21:27:45 GMT

Hi,
I am trying to generate an amortization schedule for loans based on certain inputs. So each input row will map to multiple output rows. E.g. for an input set of (Term=10,interest rate=5%, Principal = 1000,payment = 20) I want to generate the amortization over the 10year term. This requires generating multiple rows. What is the best way to go about this? Many thanks.

Re: [resolved] Generating multiple rows based on the input

Anonymous — Fri, 02 Sep 2016 03:51:57 GMT

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

Re: [resolved] Generating multiple rows based on the input

TRF — Fri, 02 Sep 2016 13:32:17 GMT

Hi,
tSplitRow is a way but maybe not the best if a lot of output rows must be generated from a single input row.
tJava or tJavaFlex to complete an array with expected values should be better (have to code).

Regards,
TRF

Re: [resolved] Generating multiple rows based on the input

ahsin — Fri, 02 Sep 2016 15:20:25 GMT

Hi,
To illustrate my scenario with an example: Suppose data (which relates to loans) has a row with the following columns: Term = 2 year, Interest rate=5%, Principal = 100. The payments of this loan are made on a monthly basis so in the output I want to have: Payment date (monthly), Interest portion, Principal portion, total payment and ending balance. So in this case 1 row will map to 24 rows (2 x 12). Hope this explains my requirement clearly. Many thanks.
AA

Re: [resolved] Generating multiple rows based on the input

Anonymous — Fri, 02 Sep 2016 16:16:42 GMT

Hi,
Are you looking for something like demarcation per month (based on your term) ? and for each month you want to calculate Principal portion .... etc?
Thanks

Re: [resolved] Generating multiple rows based on the input

ahsin — Fri, 02 Sep 2016 16:28:09 GMT

Hi ABelkacemi,
Yes, something like that. So for each month I will have columns for 1)payment amount 2) principal portion 3)interest portion 4)ending principal balance
Thanks.

Re: [resolved] Generating multiple rows based on the input

Anonymous — Fri, 02 Sep 2016 16:51:09 GMT

The data come from a database or file?

Re: [resolved] Generating multiple rows based on the input

TRF — Fri, 02 Sep 2016 18:02:08 GMT

As the number of output rows varies, the way is tJava family components.

Re: [resolved] Generating multiple rows based on the input

Anonymous — Fri, 02 Sep 2016 19:44:53 GMT

This should point you in the right direction https://www.rilhia.com/quicktips/quick-tip-row-multiplication

Re: [resolved] Generating multiple rows based on the input

ahsin — Wed, 07 Sep 2016 17:36:41 GMT

Thanks rhall, the solution worked!