getting information from left cell, if blank

[jinbaba]

below is what i have

Column1 Column2 column4 Column4
ABC ? XYZ ?

i want the question mark in column2 to be ABC and then loop all columns… so Column4 would be XYZ

help please… new to KNime and stuck!!!

[Snowy]

You can do this with the Rule Engine node. Your formula will look like this:

MISSING $Column2$ => $Column1$
TRUE => $Column2$

This will give you Column 1 if Column 2 is blank… If it’s not blank, it will give you the existing value in Column 2.

You could also probably use the Column Expressions node with the isMissing function to accomplish the same result. Rule engine is probably easiest though.

Good luck and welcome!

[jinbaba]

thanks Snowy!!! works like a charm