Alteryx Designer

Share your Designer product ideas - we're listening!
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

Automatically Create Database Table Primary Key in Alteryx

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

 

6 Comments
Status changed to: Inactive
 

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!

Alteryx Certified Partner
Alteryx Certified Partner

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

13 - Pulsar
13 - Pulsar

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

Alteryx Certified Partner
Alteryx Certified Partner

Sweet! Thanks @patrick_mcauliffe 

16 - Nebula
16 - Nebula

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