Compare Values in a Column and Grouping

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 !

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

4 Likes

Hi @ipazin

It worked, thanks a lot ! :slight_smile:

2 Likes

Glad to hear that @ellobyhn!
Ivan

1 Like

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