Replace Save As

Question

Hi,

Is there any way to replace save as command. In my case I've multiple csv files and what I wanna do is just create the excel files from that csv files, with the same name. The format doesn't matter, it could be string. I just do not want to do the manual save as for 20 files.

Thanks,

binu_acs · Answer

@Udineso you can also take a look at the below batch macro for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/ta-p/20480

Udineso · Answer

Apparently all the csv files have just one sheet, with different fields as you said. The purpose of creating excel files is simple to create a back-up.  Anyway I'll try the macro you mentioned, and I'll get back with a feedback.

Thanks Chris,

Wiktor

ChrisTX · Answer

You can use the Directory tool to get a list of your CSV file names.  I'm guessing the CSV files may have different fields?

Try the macro in this post, which imports Excel files with different layouts: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-multiple-sheets-from-one-excel-file-with-slightly/m-p/420217#M77728

Feed the list of CSV files into the macro.