Replace Save As

[Udineso]

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,

[ChrisTX]

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

Feed the list of CSV files into the macro.

See also:

Alteryx: Simple Batch Macros

https://community.alteryx.com/t5/Engine-Works-Blog/Alteryx-Simple-Batch-Macros/ba-p/2251

Chris

[Udineso]

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

[binuacs]

@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/t...