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
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive