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
The Expert Exam is now live online! Read about the specifics and what it took to bring it to life in the blog by our very own Elizabeth Bonnell!

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

Alteryx
Alteryx
Status changed to: Under Review

Hi All,

 

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

 

Best,

Alex

5 - Atom

I also would like to see this feature.

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