Automatically Create Database Table Primary Key in Alteryx

[patrick_mcauliffe]

Writing SQL to set primary keys in Alteryx before outputting the data is tedious, right?

I propose that you guys could incorporate my macro as a tool (referenced here:http://community.alteryx.com/t5/Data-Sources/Variables-used-in-Input-Path/m-p/38199#M2604).

It sure is a lot faster than going through this process: http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Create-Database-Table-Primary-Key-in-Alteryx/...

[Community_Admin]

The status of this idea has been changed to 'Inactive'. This status indicates that:

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!

[Nick612Haylund]

Did you end up dropping this macro into Gallery @patrick_mcauliffe ?

[patrick_mcauliffe]

@Nick612Haylund it'll need some updates first, but I'll let you know when it's posted.

[Nick612Haylund]

Sweet! Thanks @patrick_mcauliffe 

[SeanAdams]

agree with the suggested idea @patrick_mcauliffe  - and if you could specify the primary key on any table creation then it would remove one step from multiple data prep / ETL job for hundreds of people (as well as increasing the quality of the data through the unique constraint that comes with a primary key).