Update existing table in Sybase using Alteryx

Question

Hi,

I'm using Alteryx 2018.4.4, and trying to update a table with a primary key.

The table structure in Alteryx is exactly as is in the DB. Alteryx is even able to identify the Primary key in the DB table (screenshot attached). However, I still receive the following error when I run the workflow:

"Primary Key required for Update option"

Thoughts?

Capture.JPG

BrandonB · Accepted Answer

Can you take a look at the thread here and let me know if any of the solutions help? https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Primary-Key-Required-for-Update-Option-but-Primary-Key-Exists/td-p/194412

pereisyd · Accepted Answer

USE <DB> helped.

Thank you.