Aggregate Data By Column

Description

This activity aggregates the data in a specified column using various transformations. The aggregation is performed based on user-defined grouping criteria and aggregation functions.

Input

Data only

Output

Transformed data

---

Configuration Fields

• Group By Column Specifies the column name(s) used for grouping data.
• Aggregations Defines the set of columns and their corresponding aggregation types.
  • Column Name of the column to be aggregated.
  • Type of Aggregation Specifies the aggregation function to apply (options sum, average, count).
• Include Original
  • If enabled, retains the input data columns along with the transformed columns.
  • If disabled, only the output columns are included.
• Text Column Strategy Defines how to handle text columns within groups. Options
  • First Retains the first encountered value within each group.
  • Last Retains the last encountered value within each group.

---

Sample Input

Category	Total Sales	Units Sold	Product Name
Electronics	50000	50	Laptop
Electronics	50000	50	phone
Furniture	60000	40	Sofa
Electronics	50000	50	Laptop
Clothing	20000	30	T-Shirt
Clothing	20000	30	ethnix
Furniture	60000	40	Bed
Clothing	40000	30	pants

Sample Configuration

---

Sample Output

Category	Total Sales	Units Sold	Product Name
Electronics	150000	50	Laptop
Clothing	80000	30	T-Shirt
Furniture	120000	40	Sofa

---