How to add a new column when using the “Group By” step?

Modified on Mon, 02 Jan 2023 at 06:36 PM

By default, the Group By function outputs either a new dataset or replaces the current dataset, and it is not possible to just add a column to an existing dataset. To do so, you have to create a new dataset and then join it to your original dataset. Here are the steps you would need to follow:

  • Enable the option to Save output under different name within the Group By function and Apply the step.
  • Then add a new step below using the Join function.
  • For the Left table select the original dataset.
  • For the Right table select the new dataset output from the Group By step.
  • For the Common columns for both the left and right tables, select the column that you used as GroupBy Columns field in the Group By step.
  • For the Join method choose Left.
  • Click Apply.

You will then have a new column with the values from the Group By added into the original dataset.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article