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?
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.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 712 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive