Differences

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

--- 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.|
 |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.\\
+\\
+====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=====