[resolved] Generating multiple rows based on the input

[ahsin]

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.

[Anonymous]

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

[TRF]

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

[ahsin]

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

[Anonymous]

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

[ahsin]

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.

[Anonymous]

The data come from a database or file?

[TRF]

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

[Anonymous · Accepted solution]

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

[ahsin]

Thanks rhall, the solution worked!