Missing value node -

I am trying to add a previous value in a Missing value node, The table starts with the header, and then the missing values, it populates all the missing values except the 1st few rows due to no previous value available.

Row 1 is the header
Row 2 to Row 7 are blanks (can`t be filled due to no previous value available but the header)
Row 8 has a value of “A”
Rows 9 to 15 are filled with missing values. i.e previous value “A” in row 8

if rows 2 to row 7 can`t be filled with the header how to delete the blank rows. Thanks

The Missing Value node has an option to remove rows

image

3 Likes