ETL Pivot Help
Good morning,
I have something I'm struggling with.
In my screen shot attachment, the top table is how the data currently is. The bottom table is how I want it.
This example is just 1 drive ID (157624 far left column) and it has 2 shift id's (257650 and 257651). For every different drive id, the shift id's will be completely different, unique numbers. So this is the only instance where 257650 and 257651 will occur. I don't need those specific numbers, they just represent different shifts, with the lower of the 2 numbers always being shift 1 (in this case, 257650). These are the only pieces of data we have to identify different shifts. We don't, for example, have a column with fields that say "shift 1" or "shift 2".
Comments
-
Nevermind, I was able to figure this out.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 103 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 41 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 400 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive