Aggregate String

Aggregate strings across rows by concatenating them together, and grouping by other columns.

Uses a text separator to aggregate the string values together, and returns a single column where the rows are the aggregated strings.

Parameters

Name	Type	Description	Is Optional
agg_columns	column_list	Columns with string values to aggregate
sep	value	Text separator to use when aggregating the strings, i.e. ', '.
group_by	column_list	Columns to group by when applying the aggregation.
distinct	boolean	If you want to collapse multiple rows of the same string value into a single distinct value, use TRUE. Otherwise, use FALSE.
order	sort_direction	ASC or DESC, to set the alphabetical order of the agg_column when aggregating it

Example

product = rasgo.get.dataset(75)

ds2 = product.aggregate_string(group_by=['PRODUCTLINE'],
                agg_columns=['PRODUCTKEY', 'ENGLISHPRODUCTNAME'],
                sep=', ',
                distinct='FALSE',
                order='ASC')
ds2.preview()

Source Code

RasgoTransforms/aggregate_string.sql at main · rasgointelligence/RasgoTransformsGitHub