Iterating files through batch macro

[vibhore27]

Hi,

I have close to 100s of xlsx file which I want to convert to .csv format.

I use the batch macro to do this. I use two control parameter to provide alteryx 1) the input location from where it should read all the files, 2) where alteryx should output the .csv files

Files are getting generated but all of them seemed to remain in the .xlsx format only. None of them changed to .csv. Also, those .xlsx seemed to be corrupt (they cannot open)

I am new to alteryx, it may sound bit trivial problem. Would really appreciate if someone could help me out with this. I have attached both the macro as well as the workbook.

[LordNeilLord · Accepted solution]

Hey @vibhore27

Try the attached example

I modified your macro to modify the file path using the folder browse tool and the used the formula to build the full file path (and extension). 

See if this works for you :)

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome