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
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:
I have tried with create a new table option but every time I m getting error of ' no table are selected'.
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!