Combining Row Data
Hi everyone,
I've looked through all of the resources I can and can't find an answer to my issue so hopefully, someone here can help.
I am working with student data from a university and am attempting to combine classes and labs into one row while maintaining data from columns. I have a unique identifier for each student (OrgDefinedID), but I can't figure out how to combine the courses (OU_MasterCourses_CourseName) without combining all of the courses for the student.
I've attempted to use group by, but can't figure out how to combine them separately without combining all of the student's courses into 1.
In the example attached I need to combine 8 rows into 3 rows.
2022 Spring - Biology Survey I & Lab (BIOL-101 & 101L-BT1/BT2)
2022 Spring - Biology Survey I (BIOL-101-BT2)- don't use
2022 Spring - Biology Survey I Lab (BIOL-101L-BT1)- don't use
2022 Spring - Biology Survey I Lab (BIOL-101L-BT2)- don't use
These 4 need to be combined into 1 row.
2022 Spring - Conservation of Natural Resources (BIOL/GEOL-321-BT1)
2022 Spring - Conservation of Natural Resources (GEOL-321-BT1)- don't use
These two need to be 1 row.
2022 Spring - Evolution (BIOL-373-B01)
2022 Spring - Evolution Lab (BIOL-373L-B01)
These two need to be 1 row as well.
Any help would be appreciated.
Thanks,
Erik
Answers
-
It looks like you are wanting to pivot your data. In which case, I would recommend using the pivot tile in Magic ETL. It is built take multiple rows and turn them into columns and result in fewer rows. Here's the KB article: https://domohelp.domo.com/hc/en-us/articles/360044951294-New-Magic-ETL-Tiles-Pivot#2.
**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.1 -
Thanks Mark! It looks like this might be just what I need.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive