Listagg function or equivalent
Trying to do the following calculation so i can have all the available strings in a given column aggregated with a comma delimiter. Basically trying to correctly use the listagg function which appears to be quietly supported by domo, but still having trouble. Has anyone been able to use this function or get around it some other way? Thanks!
Scenario:
Column A | Listagg(distinct 'Column A')
Car | Car, Boat, Motorcycle
Car | Car, Boat, Motorcycle
Boat | Car, Boat, Motorcycle
Motorcycle | Car, Boat, Motorcycle
Comments
-
Have you considered using the Magic ETL to do this? You could use the Pivot/Uncollapse Columns tile to do this along with a Combine Columns tile.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
thanks for the response, Mark. In this use case i need this card to be reactive to user interaction. More specifically, i'm trying to pass page filters as pfilters and need a mechanism to pass an aggregated list of values in the event more than one of these is selected on a given page filter.
0 -
GROUP_CONCAT is the MySQL version of LISTAGG
group_concat(MyString separator ', ')
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
thanks!
doesn't appear like GROUP_CONCAT is recognized as a valid function in beast mode... ?
0 -
You cannot Group_Concat in Beast Mode / Analyzer. You have to do this in SQL or Magic AFAIK
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive