When joining two data sources, you may need to group the data in some way to ensure that the join produces the desired result. You can group the data by a particular column and then aggregate the values in the other columns

How to group by in Data Pipelines

1. After you've added at least one data source, click the Addition icon and select GROUP BY.

2. For columns that have numerical values, you are able to group the data by the following functions.

   Function	Description
   AVG	Average of the column.
   COUNT	Number of records.
   MAX	Maximum of the column.
   MIN	Minimum of the column.
   SUM	Sum of the column.
   ROUND	Round a number to s specified precision.

   ​

3. For columns that have character-type values, you only have 1 available string function.

   Function	Description
   CONCAT	Join two or more text strings into one string.

   ​