User Tools

Site Tools


transformations:aggregate

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
transformations:aggregate [2021/07/18 00:48]
craigt
transformations:aggregate [2021/09/12 11:25] (current)
craigt [Action settings]
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 by the selected //Group by// columns by using the //Aggregate by more columns// option.+More than one aggregated column can be created by clicking the //Aggregate by more columns// option and selecting the additional column and aggregation to apply.
  
 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.  Options: //Comma//, //Semicolon//, //Tab//, //Pipe//, //Tilde//, //Space//, //Line break//, or //No separator//. |
 +|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