Automating annual nodes

Hi,

My KNIME routine does calculations on financial data. Until now, I have been doing these calculations using Java Snippets. I have to do the same calculations for each year, meaning there is a great deal of manual adjustment in changing the years in the code for each snippet, and naming the column names with the year attached appropriately. Below is a *very* simplified version of how this data looks initially.

In the end, I would have several additional columns added for each year using Snippets (columns named e.g. 2011_Upsell, 2012_Upsell, 2013_Upsell) Let's say I have twelve different annual calculations that need to be done - this implies there are 12 x 5 (2011-2015) Java Snippets that need to be made with largely similar code. And in reality, it's much more complex than this..

Customer_ID 2011 Bookings 2012 Bookings 2013 Bookings 2014 Bookings 2015 Bookings
1 100k 110k 120k 130k 140k
2 20k 30k 40k 50k 60k

 

 

 

 

It has since come to my attention that I may be able to automate this process using the Loop nodes. The goal is that rather than creating a seperate Java Snippet for each year, I would create just one using the year as a variable - it would also need to name the column by inserting the year into the name of that column also.

Could you please help with this? (And please work with the structure given rather than suggesting an alternate way of arranging the data..)

Hami

Anyone?

If you could help me to understand how I can refer to the COLUMN NUMBER in the Java Snippet in a manner that can be recursively updated through a loop, that would also suffice. Thankyou!

Hi Hami Tipene,

Could you please make an example or share an example workflow based on what you want to reach?

Thank you,

Cheers,

Vincenzo