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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 473 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 209 Visualize
- 257 Beast Mode
- 2.1K Charting
- 12 Variables
- 18 Automate
- 355 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 183 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive