Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

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.

4 Comments
Olav_Amlie
5 - Atom

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.

ARich
Alteryx Alumni (Retired)
Status changed to: Under Review

Hi All,

 

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

 

Best,

Alex

kcastillo0319
5 - Atom

I also would like to see this feature.

cheerspankaj
7 - Meteor

Hi,

 

Is there any update on this feature ( the output data tool works for oracle DB table, where we can define primary key).

 

In my case I am looking to write to Hive table and cannot have primary key on it.

 

Thanks,

Pankaj