How do I merge data into single row?
I'm working on creating a card that feeds from our data set of activities. Each activity has a status (1,2,3,4,5) and is tied to an individual client.
The table produces a result similiar to this:
Activity 1 | Activity 2 | Activity 3 | Activity 4 | Activity 5 | |
Client A | Completed | ||||
Client A | Completed | ||||
Client A | Not Completed | ||||
Client A | Not Completed | ||||
Client A | Not Completed | ||||
Client B | Completed | ||||
Client B | Completed | ||||
Client B | Completed | ||||
Client B | Completed | ||||
Client B | Completed |
How can I merge the information so all client activity results are populated on one line? Would this require a beastmode or is there another option that I am missing?
Thanks,
Comments
-
How is the data organized? What does the same output you show there look like in it's raw form?
Is each activity actually it's own column?
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
each activity is individually linked to the client name. So each activity produces its own row, which is what is causing the issue.
0 -
I have done this in ETL for you:
The first step is to Group your data -
This will give you the following table -
Then you will need to only select the "complete / not complete" part. As a side note, I am not very good at regex but I have written a regex that got the job done: ([^Not Completed|Completed]*)([Not Completed|Completed])([^Not Completed|Completed]*)Now you have the following table:
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive