Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Primary Key for "create new table" option of Output tool

It would be good to have the ability to select what column to use for Primary key when using the "create new table" output option of the output data tool.


When using the "update: insert if new" output option, you receive the error "Primary Key required for Update" if table does not have primary key.


Workaround is to manually create table with primary key constraint.


Having more control over table creation would be great. Further, the ability to select a Primary key column can be extended to database Updates: There are situations where the destination table does not contain a properly defined Primary key, however, one still may want to update rows based on a column not defined as a Primary key. The table may be part of an application where modifying properties is not possible.

Status changed to: Under Review

Hi All,


Thanks for the feedback. Please continue to upvote if you're interested.




I also would like to see this feature.