In your transformation view, you can enable aggregation and aggregate columns to add the columns of the dataset.

To enable aggregation and aggregate columns:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Select Transformation views from the left-side panel.
  3. Open a transformation view from the list.
  4. Select the ellipsis icon in the toolbar, and then select Aggregate.
  5. Turn on the Aggregation disabled switch.
  6. In the Group by section, change the aggregation options for each column if needed.
  7. Select Apply.