Hi,
I am new to Knime and this forum.
I am trying to populate missing month’s values based on last available value.
Can someone help please ?
Hi,
I am new to Knime and this forum.
I am trying to populate missing month’s values based on last available value.
Can someone help please ?
Hey there,
welcome to the forum!
I think what you want to achieve is doable!
Can you clarify one thing for me:
The dates in the green box - do they exist somewhere already? I.e. Do you read them from somewhere?
Or do you only have the two dates on the “Problem” side and then there is a logic - e.g. “Fill up the current calendar year” and according to that the dates need to be generated?
On the assumption that you always start with Problem table and need to fill the whole rest of the year it can work like this:
Overview:
Download:
FillWLastKnownValue.knwf (97.5 KB)
Dear MartinDDDD,
The periods in green don’t exist.
Thanks for your idea! I will need some time to study & test this.
Does this work if I have multiple IDs with varying number of line items ? For example 01-01-20 may have values from 202401 to 202405 and I should populate an additional 7 line items.
That certainly works - all you need to do is to wrap the above logic inside a group loop.
You group by ID and then each ID will be processed one after the other:
Here is an updated WF (have expanded the example data for a new ID…)
FillWLastKnownValue.knwf (101.2 KB)
Hi MartinDDDD,
Thank you. However, I have 3 nodes which I cannot run and cannot view your settings. Are there other alternatives please ?
I wish Knime would have a single node for such processing.
Column Expressions
One Row to Many
Thanks.
When you open the WF it should prompt you to install any missing extensions… both are official knime extensions so why not just do that?