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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1K Connectors
- 267 Workbench
- Cloud Amplifier
- 3 Federated
- 2.5K Transform
- 78 SQL DataFlows
- 524 Datasets
- 1.9K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 433 Beast Mode
- 22 Variables
- 507 Automate
- 113 Apps
- 386 APIs & Domo Developer
- 8 Workflows
- 25 Predict
- 9 Jupyter Workspaces
- 16 R & Python Tiles
- 331 Distribute
- 76 Domo Everywhere
- 255 Scheduled Reports
- 65 Manage
- 65 Governance & Security
- 1 Product Release Questions
- Community Forums
- 39 Getting Started
- 25 Community Member Introductions
- 67 Community Announcements
- 4.8K Archive