Perform rule on groupby


I want to aggregate data based on two seperate parameters (Country & Product type) and then IF sum is less than x, add yes to a new column. Next, I want ungroup the data back to original and have the yes next to all rows that are relevant and make up the sum that is too small. I want to have all columns at the end again.

To do what you need

  1. Use Group by node wit 2 Country & Product type grouping and Sum as aggregation
  2. Use Rule Engine to put Yes across corresponding sums
  3. use Join node to join original table with result of Rule Engine
1 Like

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