Alert Error on Dataset
Answers
-
Hi @kacy
How are you ingesting this data? Are you attempting to do an UPSERT?
What it boils down to is that the column you're using to identify a row's uniqueness isn't unique. You'd need to reimport your data such that you don't have duplicate IDs if your keys are set to the column that denotes uniqueness. Alternatively you may need to designate additional columns as part of the upsert key / uniqueness indicator.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
HI @GrantSmith Thank you. So the issue is we want to set up an alert on the dataset because you can add filters and specifics unlike from a card. But in our data we may have duplicate rows because its different products related to 1 opportunity so there would be three rows. When I try and add the unique columns I add the opp ID and product and it is still throwing the error.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive