community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Output Data Component - Change the Pre & Post CREATE switches

On the output data component, when outputting to a database, there are Pre & Post Create SQL statement switches.  This allows for the execution of a SQL statement in the DB but only after a create table action.  To use this functionality you must have populated a table using the 'create new table' or 'overwrite' option, which is no good if you're using the Update or Append options.  Change these switches to Pre & Post SQL Statements as per the Input Data component.  This will allow you to execute SQL statements in the DB either before or after the population action.  Can be really handy if you need to execute database stored procedures for example.  

 

Please note:  You can already work around this by branching from your data stream and creating or overwriting a dummy table, then use the pre or post create switch for your SQL statement.  This is a bit messy and can leave dummy tables in the DB, which is a bit scruffy.

2 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!