Combining Different Rows into a Single Row
Hello!
Was wondering if there is any Domo function/beast mode that can be utilized to combine results of a column across multiple rows to display in a single row.
For example, if I had company name and office locations:
Row 1: XYZ | Pittsburgh
Row 2: XYZ | Fresno
Row 3: XYZ | Dallas
Could I have it so Domo shows 1 record versus 3 and displays as:
Row 1: XYZ | Pittsburgh, Fresno, Dallas
0
Best Answer
-
Hi @user077529
You can utilize a Group By tile in a Magic ETL dataflow to group your rows together and then use the "Combine strings by ," option in the group by tile.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
Hi @user077529
You can utilize a Group By tile in a Magic ETL dataflow to group your rows together and then use the "Combine strings by ," option in the group by tile.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Welcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InWelcome!
It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign InCategories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 308 Workbench
- 6 Cloud Amplifier
- 10 Federated
- 3.8K Transform
- 660 Datasets
- 117 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 84 App Studio
- 46 Variables
- 780 Automate
- 191 Apps
- 482 APIs & Domo Developer
- 84 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 413 Distribute
- 121 Domo Everywhere
- 281 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 49 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive