Community
Community
Forums
Forums
Ask questions, help other users, get involved.
Getting Started
Take full advantage of all the forum has to offer.
Categories
Browse discussions by category.
Ideas Exchange
Help shape Domo by sharing your product ideas.
Blogs & Groups
Community Blog
Get tips and best practices from Domo users.
Events & Meetups
Network and swap stories at virtual & hybrid events.
Domo Innovators
Take challenges, build Domo skills, win prizes.
Domo Ovation Awards
See how community members rock their Domo.
Domo For Good
Help a non-profit with a meaningful data project.
Help
Help
Getting Started
Get started with Domo
Here's what you need to know to start using Domo.
Data Creators & Analysts
Learn to analyze data and create reports for others.
Data Consumers
Learn to create, view, and interact with data.
Data Engineers
Learn to integrate, govern, and build data assets.
Knowledge Base
How-To-Articles
Get detailed instructions about how to use Domo.
Release Notes
Stay current with new product enhancements.
How-To-Videos
See how to complete key tasks with Domo.
Support
Get product assistance from Domo Support.
University
University
Self-paced Training
Get on-demand eLearning modules for your role.
Virtual Training
Get remote live training in a public or private class.
In-person Training
Book a trainer to come get the team up to speed.
Certifications
Get Domo certified and build your resume.
Developer
Developer
Get Started
Start your free trial to start developing on Domo.
Docs & APIs
Use Domo to connect, process and access data at scale.
Manage Client IDs
Log in to manage client IDs
Domo.com
Support
Home
Community Forums
Connectors
Can i convert columns to rows?
Shevy
I have a data source that has data in columns based on dates or Yearmonth formats. I need to pull some of that data out and convert it to a row. For Example: Column 1 Column 2 201510 500 201511 600 201512 700 201601 300 201602 900 I need to create a table: 201510 201511 201512 201601 Row 1 500 600 700 300 Can I do this with a Magic ETL or will I have to use a transform? Any thoughts and ideas will be appreciated!
Find more posts tagged with
Accepted answers
Shevy
The simple answer is yes you can - there is a Magic ETL widget "Uncollapse Columns" that will do what you are looking to do in Magic. I have not used it yet, so i cannot give you step by step instructions but i saw a demo at appeared fairly straight forward.
All comments
Shevy
OK so that did not post well.... First table Colums are dates and values Output table puts the dates as column headers and the values as a single row.
Shevy
The simple answer is yes you can - there is a Magic ETL widget "Uncollapse Columns" that will do what you are looking to do in Magic. I have not used it yet, so i cannot give you step by step instructions but i saw a demo at appeared fairly straight forward.
Quick Links
All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of
