Group by Sql builder
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.
Options
Section titled “Options”The following table provides a description of the options available for the Group By step:
| 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 |