I have an issue trying to amortise a loan with an interest rate forecast.
I have been able to do this for a fixed interest rate through the use of a recursive loop and rewriting over the columns.
I need to replicate this but read in the interest rates from a separate table.
Any help would be appreciated.
Hi @LiamFoster -
Welcome to the forum. Would you mind posting your existing workflow? Then someone could adapt that, and maybe save some time on both ends.
Knime_Upload_Forum.zip (57.4 KB)
Here is the existing workflow. The table called interest rate forecast is what I want to read into the loop as the iteration changes.
How about this? New nodes and functionality are highlighted in the yellow annotation box.
Knime_Upload_Forum_SF.knwf (67.4 KB)
Hi Scott, that works perfectly.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.