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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 194 Visualize
- 253 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 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
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive