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
18 - Pollux
18 - Pollux

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
18 - Pollux
18 - Pollux

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
Top Solution Authors