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.
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.