You can aggregate columns in your transformation view to add the columns of the dataset.
To aggregate columns:
- Select Transformation views from the left-side panel.
- Select a dataset from the list.
- Select Aggregate .
- Turn on the Aggregation switch.
- Select the columns you want to Group by.
- Adjust either the Group by or Aggregations selections.
- Select Apply.
