Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop 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