Comparison between columns in my data set

KNIME Analytics Platform
1

What node should I use for this kind of scenario?

  1. 1 input file with multiple columns
  2. Wanted to check if all in Column A (under the same category) have the same description from column B
2

You can create a conditional column using Rule Engine node to check the pairs resulting in 0 or 1.

Then, you can use a GroupBy node applying sum(Check) and, so, Rule Engine again to check if the Sum is 0. If > 0, then on some row it (the columns A and B) doesn’t match.

3

i’m kinda lost in using the rule engine node :frowning:

4

$col_A$ = $col_B$ => 0
TRUE => 1

The upper rule can be read as “if col_A equals to col_B in the current row, then new column receives 0 in the current row. If not, then receives 1 in the current row”.

If my answer was usefull to solve your problem, please check as the solution.

1 Like
5

You could also use the Column Comparator node followed by a Groupby node. Same logic as @ricardo_martins solution.

6

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