Beastmode listagg/group concat
Hello,
I usually refer to the list of magic etl functions documentation for functions that I can potentially use in beastmode since some working functions do not exist in the list within the beast mode editor.
However, a function that can combine strings from multiple rows into a single string like GROUP_CONCAT and LISTAGG does not work in beast mode. Is there any alternative to this?
By the way, the reason I don't do it in the ETL or SQL is because I want the output to be responsive to card filters.
Here's a particular use case, if I have a dataset with the fields: accounts, end users, date, and products, and I want to see all the products the accounts have sold to their unique end users in comma-separated values, and I want it to be responsive to filters. Say, if I filter only for the last 12 months, and the concatenated products should only show all the products sold in the last 12 months without duplicating the accounts by end user rows.
Thanks in advance
Best Answer
Answers
-
In the new ETL features, the Group By tile now has a concatenation for strings. Have you tried it?
** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
Hey @ArborRose,
Yeah I've tried it before, but I intend this to reference the month filters, that's why I didn't do it in the ETL this time and I'm searching for ways to be able to do it in the beast mode.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive