DOMO importing columns from Google Sheets that don't exist.
I'm importing some data from google sheets. I occasionally edit the columns in the sheet. When I re-import the data in DOMO, it keeps importing the now deleted columns. The deleted columns also continue to show as a selection when making a card.
Any Idea how to fix this? The only success I've had was to delete the data source and re-import it as if it were brand new.
Best Answer
-
@Sweep_The_Leg You know what, I just looked at the connector and it doesn't look like it actually has the functionality to switch between append and replace. Interesting.
Have you tried creating a brand new dataset and importing the sheet, do the old columns still pull over? This could be a legitimate connector bug that should be reported. It's also concerning that changing the schema doesn't carry through to the final output dataset. Both of these things should probably be reported through Domo Support.
Let me know if you have any additional questions.
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
Answers
-
Hey mbauer,
Do you by chance have the dataset set to append, rather than replace? The only thing I can think of is that the connector is attempting to append a new schema to the old one, so you get the old columns as well.
If that's not the case, I would recommend reporting a bug to Domo Support.
Let me know if the above is helpful!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Sorry for the late reply. Unfortunately I don't see the settings for either Append or Replace.
0 -
@Sweep_The_Leg You know what, I just looked at the connector and it doesn't look like it actually has the functionality to switch between append and replace. Interesting.
Have you tried creating a brand new dataset and importing the sheet, do the old columns still pull over? This could be a legitimate connector bug that should be reported. It's also concerning that changing the schema doesn't carry through to the final output dataset. Both of these things should probably be reported through Domo Support.
Let me know if you have any additional questions.
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1 -
Yes, it seems the only way to correct is disconnect entirely and re-import as if it were brand new. But I'll take your suggestion and report it to the support team.
Thanks again!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive