If-then question

I have what seems like a simple question but I cannot figure out a straightforward way to do it in KNIME. I have a Col A which has some missing values. I used the rules engine to make Col B which is groupings of Col A. In the event Col A data is missing, I can use data in Col C to assign a Col B grouping. How do I do that?

It seems like there should be a simple way to do “If Col A is missing then Col B = Col C” but I cannot figure it out.

Thanks in advance,
Eric

Hi,

In the Rule Engine node which you have created Col B, you can use this:

MISSING $Col A$ => $Col C$
TRUE => $Col A$

Using this expression, whenever the Col A is missing then the Col B value (the output result of the node) would be Col C, if Col A is available then the Col B value would be Col A.

:blush:

3 Likes

The Column Merger node will also do what you want. Use ‘Col A’ as the primary column, and ‘Col C’ as the secondary column

Steve

4 Likes

Thanks, this is what I wound up using. Appreciate the help and quick response.

3 Likes

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