In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Update existing table in Sybase using Alteryx

pereisyd
7 - Meteor

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?

2 REPLIES 2
BrandonB
Alteryx
Alteryx

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...

 

 

pereisyd
7 - Meteor

USE <DB> helped.

 

Thank you.

Labels
Top Solution Authors