This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Incorta Community
- Product
- Product Ideas
- Create List of Distinct Values Aggregate Function ...
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
mmastropaolo
Cosmonaut
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
01-17-2024
11:40 AM
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.
2 Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
