This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Now that it's live, don't forget to accept your certification badge on Credly today! Learn more here.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
I have a requirement where I had to load multiple files to multiple tables in SQL Server and these tables should created on fly based on file data. I can do this for one file where I can have input data tool for connecting a file and output data tool with SQL Server connection and select create table option for creating table based on incoming data. I would like to automate this process for multiple files in a folder. I was able to do this in SSIS using C# code (but it is taking a lot of time) and not able to find a way in Alteryx.
You will be able to build such process using a concept called Batch Macro. You will essentially build the process for one file, turn it into a batch macro and then use the list of files as an input into this process. The macro will run all the files through the same pipe.