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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive