Replace missing column by previous column in the same row

KNIME Analytics Platform
1

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)

2

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
3

Yes, it does! Thank you very much!

4

Glad I could help. Please mark solved.

5

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