I have a table with several variables for monthly time periods for each of several cases. Please see attached sample. As you can see there are many cells that are missing data. I would like to fill each such cell with the data from the previous month for that variable of that case.
I have spent a couple of days trying to adapt what is on the Forum. I have tried various nodes, including loops, Missing Value, the new Expression, and I have not been able to do this. For example, even after transposing into rows, Missing Value doesn’t seem to use Previous and leaves missing alone. (Yes, it shows a red question mark, so KNIME indicates it is missing.)
Please send any suggestions or show any workflows that might do this. Thank you.
Testdata.csv (8.6 KB)