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.” -Superman
______________________________________________________________________________________________1
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有