With "List Aggregate" function within dataflow, allow option to add space after delimiter

Dorothy Joseph-Oracle

This request is regarding the "List Aggregate" option with in a Dataflow Aggregate function that allows one to aggregate text fields using delimiters such as comma, semicolon…etc.

One issue with this option is that there isn't a way to add a "space" between the values and the delimiter which results in one long string. This becomes an issue when trying to use that text field in any visualization (mainly table) because without any spaces in it, the text does not wrap around within the column and we quickly run out of room on the screen to display all of the contents in that field. This is an issue with both DVs and Classic Analysis. Long text strings with spaces in them have no issues with text wrap.

As a workaround, I have had to transform each of the columns to add a space to the value BEFORE applying the aggregate function. In a long workflow with multiple branches/joins/aggregation, this adds to a lot of different steps.

Ideally it would be much simpler if the "List Aggregate" function allowed the addition of a space with the delimiter.