How to Capture Transactional Data Changes in Domo
We are loading sales order and purchase order data via Workbench from our ERP to report on booked orders, open orders, etc. However, our sales orders may be opened for a long period of time and frequently change. For example, the customer may revise their quantities ordered throughout the month prior to shipment. The only thing that changes is the value of the 'Quantity' field on the sales order line item.
As a complete newbie, I'm looking for advice as to the best way to capture these trasactional changes? I would prefer not to do a full dataset replacement during each load as the dataset is fairly large (and growing) and we would like to have relatively frequent updates. If I append data, I'm afraid I will get duplicates.
Any thoughts on the best way to handle this?
- 10.7K All Categories
- 13 Getting Started in the Community
- 41 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.5K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 303 Use Cases & Best Practices
- 503 APIs
- 120 Apps
- 48 News
- 753 Onboarding
- 1.2K 日本支部
- Private Company Board