Replace missing column by previous column in the same row

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)

I’m not sure this does what you want, but take a look.
Replace missing column by previous column in the same row.knwf (155.7 KB)

2 Likes

Yes, it does! Thank you very much!

Glad I could help. Please mark solved.

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.