Moving empty cells up


Can someone help me on how can I shift the cells up when the value is missing in the cell?

I am having empty rows and the first thing is I need to move up the cell.

I tried using java snippet and missing rows, but then I couldn’t able to do.

Please suggest


First mark the lines that have Valies in the first three columns but no date for later deletion.

Use missing values node to replace missing for first two columns with the previous value.

Do the same with the type of leave colum, yes then enties will go to the wrong line.

Delete the previous marked lines.

In the missing values node the settings look like this but use the previous row instead of moving average.

1 Like


Thanks a lot. Its working now :slight_smile: