cancel
Showing results for 
Search instead for 
Did you mean: 
mmastropaolo
Cosmonaut
Status: New

I propose adding a function similar to Spark SQL's concat_ws(collect_set()) in Incorta Analyzer. This aggregate function would enable users to aggregate and concatenate distinct values from a group into a single string, enhancing data analysis capabilities within Incorta dashboards.

Current State: Currently, in order to get a list of values grouped by a particular field, it is required to create a materialized view.

Example: Consider a dataset of customer purchases. When grouping by customer and utilizing this new function, it would output a distinct list of all customer ordered products for each customer.

Incorporating this functionality would greatly benefit users who need lists aggregated at a variety of levels for additional context in analysis.

1 Comment
IamtheLaw382
Ranger

Yes please!