Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Alteryx Output Data into a MS SQL View

Asteroid

Hi there ,

Is there any way to output data into a view rather than a table in Alteryx? 

Thanks. 

 

Highlighted
Alteryx
Alteryx

@Amy18 

 

As a view is ultimately a virtual table - a definition built on top of other tables (or views) which doesn't hold data itself - you will need to create a table first.

You can use the Output data tool to create a table and then a post create sql statement to build a view on the back of the table. 

 

post-sql.png

Labels