Create List of Distinct Values Aggregate Function in Incorta Analyzer

[mmastropaolo]

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.

[IamtheLaw382]

Yes please!