Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

SQL table connection through output Tool

Puneet13
8 - Asteroid

I need a help wherein I have multiple Input and I want to these output in a SQL table, currently I have no table available in SQL to add data, can somebody tell me how to create a table using Alteryx with data automatically paste in the SQL table or any other procedure use to insert the data into table. Also I want to delete the data from the SQL table and insert new one. Can somebody help me with sample workflow where in above steps are coveted

3 REPLIES 3
alexnajm
17 - Castor
17 - Castor

Attaching a workflow will be a challenge since we don't know your workflow and don't have your SQL connections, but all of the output options you mentioned are in the Output Data tool:

SQL table connection through output Tool.png

Puneet13
8 - Asteroid

I have tried with create a new table option but every time I m getting error of ' no table are selected'.

alexnajm
17 - Castor
17 - Castor

That will all depend on your connection settings (i.e. do you have create/write access) and the database you are connecting to - I would search on the Community for those specifics and try again!

Labels