Compare Values in a Column and Grouping

KNIME Analytics Platform
1

Hi everyone,

I need help on comparing the values in a column and if they are equal, check another column. If they are also equal, write ‘equal’ in a new column. For example:

If ‘Master’ column are equal in 3 raws, check ‘Price’ column. If they are also all equal each other, write ‘equal’ in another column for these rows. If prices are not equal, write ‘not equal’

Case

Thanks in advance !

2

Hello @ellobyhn,

use following nodes:

  • GroupBy node to get minimum and maximum Price per Master
  • Rule Engine node to output “equal” if min = max else “not equal”
  • Joiner (Labs) to do perform Left Outer join based on Master to add newly created column

Give it a try and if you’ll have any questions/issues don’t hesitate to ask!

Br,
Ivan

5 Likes
3

Hi @ipazin

It worked, thanks a lot ! :slight_smile:

2 Likes
4

Glad to hear that @ellobyhn!
Ivan

1 Like
5

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