How to transpose rows to columns using ETL
Hi,
I have a large dataset that has thousands of rows, most of those rows have the same value for most columns except for one. I'm trying to transpose the value from the rows that are in one column to multiple separate columns, removing the duplicate lines. I know the "Pivot" function in ETL is what i need to use, but i'm stuck because it is not very on how to use the function.
Any help is appreciated!
Thanks,
Comments
-
@user061574 Check out this Knowledge Base article. Focus on the "collapse" and "uncollapse" columns pieces.
https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns
2 -
@swagner was absolutely correct the equivalent of PIVOT in Domo will be the Collapse / Uncollapse columns magic ETL tile. It's a bit of a bear b/c unlike SPREAD / GATHER / MELT from Python and R, you have to manually assign each column and unless you know Dynamic SQL there is no way to dynamically implement PIVOT / UNPIVOT in Domo AFAIK.
that said, i would be very careful and examine whether I actually need to Pivot the data for the visualization requirement. Depending on the use case, clever Beast Modes with CASE statements or Pivot Table cards can get the job done gracefully without having to process large datasets in ETL.to befair, the definition of 'large' varies, so maybe it's fine!
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
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
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 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