New Excel Files as Data Sets Creating Extra Columns

I am currently attempting to set up new Data Sets in Domo by loading Excel files containing daily budget data for multiple departments. However, once the file is loaded into Domo it shows two extra columns as follows:
These extra columns are breaking the dataflow where the file is needed.
Your assistance is very much appreciated.
Elvira Bannon
Best Answers
-
That is a normal pivot added by the upload process to provide helpful Meta data on the underlying dataset - so you didn't do anything wrong!
To ensure your ETL still runs as expected - throw a "Select Columns" tile prior to the transforms (upstream) and remove those 2 metadata columns.
✅Did this solve your problem? Accept it as a solution!
❤️Did you love this answer? Mark it as "Awesome"!
👍Do you agree with this process? Click "Agree"!
1 -
Thank you so much for your help! This is exactly what needed to be done.
0
Answers
-
That is a normal pivot added by the upload process to provide helpful Meta data on the underlying dataset - so you didn't do anything wrong!
To ensure your ETL still runs as expected - throw a "Select Columns" tile prior to the transforms (upstream) and remove those 2 metadata columns.
✅Did this solve your problem? Accept it as a solution!
❤️Did you love this answer? Mark it as "Awesome"!
👍Do you agree with this process? Click "Agree"!
1 -
Thank you so much for your help! This is exactly what needed to be done.
0
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 87 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive