Failed to Execute - Domo Workbench
Best Answer
-
I haven't used pivot tables as source myself, so I can't answer that. But I don't think WorkBench wouldn't care as long as you can define the area of rows & columns.
Example, I screenshot this image from an online pivot table example (below). If I set WorkBench to read the whole table I would expect it to fail.But you can tell it the sheet and the start and end points for your data. So you can tell Workbench to use data from A4 through I11 and it would have no trouble. But if I tried to include row 3, it would have a problem because row 3 has 2 fields available and row 4 has 9. That's a mismatch. Does it create a dataset of 2 fields or 9? It can't do both. So it would error.
The error you mention could also be caused by something in the data or formatting causing it to think its not in the simple row by column format. A filter dropdown like shown in the example may cause an issue. Or bad date formatting or errant characters or something.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Answers
-
The error indicates that there's an issue with the way you're referencing positions in your Workbench job. Make sure your fields are in the correct order and that the data structures match. Such as date formats.
Oh….also make sure you have your data laid out without merged rows. All rows should lay out with specific columns. If you have headings over the top of columns of data….remove the headings so Workbench can see the layout as
ROW1 COLUMN1 COLUMN2 ETC
ROW2 COLUMN1 COLUMN2 ETC
ROW3 COLUMN1 COLUMN2 ETC** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0 -
I'm using an excel file that is a pivot table, it needs to stay in this pivot table view since i'm connecting to an internal data warehouse. Would that have anything to do with it?
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0 -
It's called an OLAP query. @ArborRose
IF I SOLVED YOUR PROBLEM, PLEASE "ACCEPT" MY ANSWER AS A SOLUTION. THANK YOU!
0 -
I haven't used pivot tables as source myself, so I can't answer that. But I don't think WorkBench wouldn't care as long as you can define the area of rows & columns.
Example, I screenshot this image from an online pivot table example (below). If I set WorkBench to read the whole table I would expect it to fail.But you can tell it the sheet and the start and end points for your data. So you can tell Workbench to use data from A4 through I11 and it would have no trouble. But if I tried to include row 3, it would have a problem because row 3 has 2 fields available and row 4 has 9. That's a mismatch. Does it create a dataset of 2 fields or 9? It can't do both. So it would error.
The error you mention could also be caused by something in the data or formatting causing it to think its not in the simple row by column format. A filter dropdown like shown in the example may cause an issue. Or bad date formatting or errant characters or something.** Was this post helpful? Click Agree or Like below. **
** Did this solve your problem? Accept it as a solution! **0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K 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
- 748 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
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 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