Manually Edit Data in a Dataset
Hey everyone,
I'm trying to figure out a way to edit data within Domo.
Every evening we take a snapshot of our open orders (directly from our ERP via a webservice).
The snapshot records for each day are appended to the dataset and we use them to calculate a planned vs actual variance for the day.
This works well if every order is completely up to date at the time of the snapshot, however that isn't always the case.
If we correct the order the next day, then the snapshot record for the new day is correct but the old snapshot and the variance for the previous day stay wrong forever.
Is there any way to edit a specific record in a dataset within Domo? Or maybe some option to export the entire data set, edit the spreadsheet, and upload it to overwrite the data?
Thanks
Comments
-
You can use DOMO workbench connector to export your data into DOMO from a specific location on your local network. If you want to edit the data manually just open the file locally, make the necesssary changes and save the file. Every time a file save is detected DOMO auto exports and update the data in datacenter.
0 -
Hey NFSharma,
Thanks for the suggestion. I understand I can use local data as the source of my data set, but this dataset is coming directly from our ERP via a webservice. Occasionally the data is incorrect in the ERP when the snapshot is taken and I need a way to modify the old snapshot data.
0 -
Is the append manual or automated? I think Recursive workflow can solve this issue ?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive