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

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.