Using Domo Workbench, how to I set it to upload my my rows as headers?
Currently, I am trying to upload Excel through Workbench. My data is set up as column A as the header and column B-Z as dates. How do I have Workbench upload Column A as the header. Domo has the capabilities to swap rows/columns through their manual uploads. Any suggestions?
Comments
-
0
-
I'm not familiar with a method for pivoting the data in workbench. You can, however, upload the data as is and then use the Collapse Columns transform in Magic ETL to pivot the data and create a record for each Column A & Column B-Z combination. Could that be an option for your data?
0 -
@Dhoeppner, did zcameron's reply help you out?
0 -
Does a solution in the workbench meanwhile exist? Would be very helpful
0 -
No, nothing has been added to Workbench to handle this. You could, however, create a script that could do this manipulation and then have Workbench call that script (using the External Process File Provider job type) and then upload the output of the script for you.
0 -
You could create a second tab in excel to do the automatic pivoting for you. Inconvient but that is how I would do it.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 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