How to fix processing error in upsert?
Options
Hi all,
We are trying to update our data via the merge update option (please see the image below).
We are also updating our query in the "details" section with a statement like
SELECT columns
FROM table
WHERE tiemstamp>tiemstamp of last run
But every time we try it we get the following error message:
What does this error mean? If we run the dataset again, it returns the same error, so it is not fixed. Are we doing something wrong in how we are implementing this? FYI: Domo has already implemented the upset functionality, so we should be able to do this. Mainly, we want to undertsand what the error means, so if anyone can help, this would be much appreciated. Thanks!
1
Comments
-
Hi,
Is anyone able to help out with this request?
Thanks,0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive