Update insert if new

[jminns90]

I'm trying to check a sql database before inserting new records because I don't want to enter possible duplicates. In sql the primary key is set as a varchar(117) and in Alteryx it is a Vstring(117). The error I get is Error: Output Data (68): Primary Key required for Update option. Is there a fix for this? Or another clever way to get around it? Thanks

[TimN]

See if this helps.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Primary-Key-required-for-Update-option...