Welcome to the Alteryx Knowledge Base
Dataverse output error: Unique Identifier column not found
Created/Edited -
Description
While using Alteryx to perform an upsert operation on a Dataverse table, the system failed to recognise the designated primary key column.
Issue
Environment
Dataverse Tool version: 1.2.1 and 1.2.2
Cause
The column had duplicate values, which violated the uniqueness requirement for a primary key. The duplicate values were due to repeated test inserts. The Dataverse table expected a truly unique identifier for upsert operations.
Resolution
- Delete duplicate records from the table to ensure the primary key column has unique values.
- Recreate the unique identifier column within Alteryx and then use it
- Run the upsert operation, which updates existing records without inserting duplicates.
Was this article helpful?