transformations:aggregate
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
transformations:aggregate [2021/07/18 00:48] – craigt | transformations:aggregate [2021/09/12 11:25] (current) – [Action settings] craigt | ||
---|---|---|---|
Line 23: | Line 23: | ||
|Aggregation method|Select the aggregation method to be used on the values in the chosen column.| | |Aggregation method|Select the aggregation method to be used on the values in the chosen column.| | ||
|Group by|Select the column(s) in which the grouping of values will drive the aggregation.| | |Group by|Select the column(s) in which the grouping of values will drive the aggregation.| | ||
- | You can aggregate more columns | + | More than one aggregated column |
The output of this action is a dataset containing the "Group by" column, plus an additional column for each aggregation chosen.\\ | The output of this action is a dataset containing the "Group by" column, plus an additional column for each aggregation chosen.\\ | ||
+ | \\ | ||
+ | ====Concatenate settings==== | ||
+ | ^Setting^Description^ | ||
+ | |Separator|Select the character (delimiter) that will appear between the concatenated values. | ||
+ | |Distinct|When checked, only unique values in the aggregated column will be included in the concatenation.| | ||
\\ | \\ | ||
+ | |||
=====Examples===== | =====Examples===== | ||
transformations/aggregate.txt · Last modified: 2021/09/12 11:25 by craigt