Group By SQL Builder
Overview
Section titled “Overview”This step allows you to calculate values over a defined group of fields. Examples of common use cases are: calculate the average sales per product or get the number of yellow shirts that we have in stock.
This step read data using SQL Group by from specified table.
Configuration Options
Section titled “Configuration Options”| Option | Description |
|---|---|
| Step name | Name of the step; this name has to be unique in a single transformation |
| Connection | The database connection to which data is read from |
| Schema | The name of the Schema for the table to write data to. This is important for data sources that allow for table names with periods in them |
| Table | The name of the table to which data is read from |
| Group fields table | Specify the fields over which you want to group. Click Get Fields to add all fields from the input stream(s) |
| Aggregates functions | Specify the fields that must be aggregated, the method and the name of the resulting new field. Here are the available aggregation methods: Sum, Average, Minimum, Maximum, Count |
Related
Section titled “Related”- Transforms Overview - Overview of all transforms
- Multi Union - Combine multiple streams