Combining Row Data
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.
- 11.4K All Categories
- 6 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 45 Domo News
- 10.3K Using Domo
- 2K Dataflows
- 2.6K Card Building
- 2.3K Ideas Exchange
- 1.3K Connectors
- 356 Workbench
- 272 Domo Best Practices
- 14 Domo Certification
- 484 Domo Developer
- 58 Domo Everywhere
- 114 Apps
- 736 New to Domo
- 86 Dojo
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 32 お知らせ
- 65 Kowaza
- 305 仲間に相談
- 668 ひらめき共有