Dataset with weeks as columns, need to pivot weeks into one column
Hi,
How can i pivot a dataset which has the weeks as columns? I need to create one column with the weeks and the values within another column. This will enable me to provide charts more easily.
thanks for any ideas! i'm sure it's within redshift functionality, but i'm stuck.
thanks!
Best Answer
-
Hi, this is very simple to do in magic etl , take a look at link below for instructions on how to "Collapse Columns"
it is in the knowledge base and here it is the link
https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2
Answers
-
In terms of pivot tables the only thing I found that worked well was a sumo card. It gives you the open to create pivot tables and move around what you want to pivot. I'm not sure if this is what you're looking for, but when I ran into something similar this card helped me achieve what I needed!
Let me know if you find anything else that works!
-Carter
0 -
Hi, this is very simple to do in magic etl , take a look at link below for instructions on how to "Collapse Columns"
it is in the knowledge base and here it is the link
https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/02ETL_Actions%3A_Edit_Columns
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'2 -
Thanks Godeipi! This was the perfect solution.
0 -
Carter - thanks for the idea. Check out the solution from Goedipi, it worked really well!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive