Refresh an excel file that has data and a pivot table
I have an excel file that is connected to a dataset on one table and on another table I have a pivot table from that data. What I would like to know is how do I use DOMO to schedule that file to refresh the data and refresh the pivot table and then send it as an attachment to a user.
Is that possible?
Best Answer
-
@Brewha51 Gotcha. In that case, not having access to the instance eliminates most out-of-the-box solutions if accessing the raw data is a requirement. You may be able to script something locally that refreshes and fetches the data using the Domo API, then sends the file as an attachment. I'll admit that is not my area of expertise, so I'll throw this one out to anyone else in the community who knows more about that.
0
Answers
-
Hi Brewha51! Within your dataflow "Settings" tab, you can set the time that the Dataflow will update. You could just have it update every night so its always fresh.
Then, you could set an alert that triggers when the dataflow updates, and that alert could send the update to everyone.
Am I on the right track here?
✅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"!
0 -
@Brewha51 Have you considered using a Pivot Table card in Domo instead of an Excel file? You can use an alert/scheduled report as @Data_Devon suggested to send an email with the card details.
0 -
Thanks @Data_Devon and @MichelleH a perfect example is for me to point DOMO to an excel file that has a tab of raw data that gets refreshed and on another tab in the same excel file, there's a pivot table from that data. DOMO would pull that excel file in every month, refresh it and email the entire excel file on a schedule. I'm not sure if that's doable, but that's the desired outcome. Hope that helps explain my thinking!
0 -
Great point! They do not have access to our DOMO instance
0 -
@Brewha51 Gotcha. In that case, not having access to the instance eliminates most out-of-the-box solutions if accessing the raw data is a requirement. You may be able to script something locally that refreshes and fetches the data using the Domo API, then sends the file as an attachment. I'll admit that is not my area of expertise, so I'll throw this one out to anyone else in the community who knows more about that.
0 -
Thanks @MichelleH!!
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