You’re offline. This is a read only version of the page.
601
I have a dataflow that upserts data into an existing table.
I have set a unique key, which should be used to detect if a record already exists, and if so, it should be updated.
However, the flow does not run succesfully, because it complains the key already exists...
the (Dutch) error message translates to: A record with the attribute values xxxxxxx already exists. The entity key xxxxxxxxx requires this set of attributes to contain unique values. Please select unique values and try again.
So, it does detect that the key already exists, but it somehow does not update this record...
Any idea why this update is not working?
Hello, @KoenJanssensPD , Your unique key should be the alternate key in the table. And you should map it to primary key of your source. Note, alternate keys can't have duplicates.
| If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more. I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends. Visit my Blog: www.powerplatformplace.com
|
Share
Report
All responses (
Answers (
