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 300 excel XLSX files that I need to get converted into CSV comma delimted files. I typically use a VBA script in excel, that goes to the folder where I have the files saved and goes through and creates a copy of the excel file as a CSV format. I would like to be able to do this in Alteryx.
Can someone help me figure out a batch macro that that do this?
Here is an example of how you could build it as an app where all you have to do is select the input and output folders. You have to run it as an app, and not just a standard work flow. Let me know if you have any questions.
Here are the screen shots, i have broken it out into three pieces:
The first is the actual app, which takes two inputs(The two folder browsers). The First browser creates a list of all .xlsx files in the chosen directory, then second is the output directory and through the formula and append tools we create a final file path. All that is fed into a batch macro.
The batch macro controls three things, The first sets the file to get all the sheet names from an excel file and the second sets the file name in the dynamic input tool (i was having issues with sheets so that is why i switched to this method). The third one is overriding the output file name to the final file name we built in the app step.
Here is a quick screen shot of the set up for the first two action boxes. The third one is just set to the default update value.
I think its because you have nothing in the text input. You can put whatever you want in there, it just has to be something because that's what the action is replacing. See attached photos for more info