Every month I need to update forecast numbers using the latest month. My upload file will add every closing of the month the current period. Meaning that I will have at the end of the year 12 periods of data. What I’m trying to accomplish is finding a dynamic way of Knime including only the latest period in my pivot table.
I added a very simple table creator with a pivot node for visualization purposes
Below is the desired result based on the latest period only:
I am trying to avoid the manual selection/unselecting columns but I’m having trouble finding an approach.
The solution @eamendola came up with is the way to go in my opinion. But if you have a good reason to filter the columns after the Pivoting node, maybe this wf Dynamic Period Selection_v2.knwf (18.4 KB) is a possible solution.