Is there any way to connect or join an excel spreadsheet to a dataset that is already in Domo?
Hi All!
I am new in Domo and I don’t have an IT background but I have gone through the Domo Certification Training (pending the tests). I am trying to get my excel spreadsheet to get updated every time the cards in a dashboard in Domo updates, I have tried to use Magic ETL to join my data but I have not been able to get an Output DataSet that would work for what I need since both datasets doesn’t have any matching columns or have the same data structure.
I provided a screenshot as an example. Is it possible for the Forecast excel spreadsheet to update every time the numbers on the domo dashboard updates?
Thank you in advance and please excuse my lack of experience and knowledge.
Best Answer
-
Hi @MDavis ,
Yes! You can use the Microsoft Plugin from Domo. Here's a video I made to show you how: https://www.loom.com/share/d042cc7f705a4489a57340da9ebf5ae0.
Good luck,
John Le
More videos at: https://www.dashboarddudes.com/pantry
John Le
You're only one dashboard away.
Click here for more video solutions:
1
Answers
-
Hi @MDavis ,
Yes! You can use the Microsoft Plugin from Domo. Here's a video I made to show you how: https://www.loom.com/share/d042cc7f705a4489a57340da9ebf5ae0.
Good luck,
John Le
More videos at: https://www.dashboarddudes.com/pantry
John Le
You're only one dashboard away.
Click here for more video solutions:
1 -
Thank you John, I appreciate your time in creating a video!
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
- 60 App Studio
- 41 Variables
- 688 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 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