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/RasgoTransforms
GitHub

Name	Type	Description
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

Last modified 1yr ago