Aggregate

In this document, you will explore how to aggregate in Astera Dataprep.   

1. To aggregate in Astera Dataprep, you can click on the Transform option in the toolbar and select Aggregate option from the drop-down.

1. Once selected, the Recipe Configuration – Aggregate panel will open.

1. Here, you can configure the Aggregate section by selecting column names in the Name drop-down, adding any expressions in the Calculation column, and selecting an Aggregate Function from the drop-down with all the aggregate functions.

1. Once done, you can click on Apply

Now, in the grid, you can see that the columns have been grouped by the EmployeeID and a Count aggregate function has been applied to the OrderID field.

This concludes the document on using Aggregate in Astera Dataprep.