INPUTTING MULTIPLE ZIPPED FILES USING BATCH MACRO

[dunkindonut7777]

Hi I have a multiple files with .csv format with huge size that are being zipped. I want to know the easiest way to input aside from wildcard method. I want to know how to utilize the batch macro in inputting the files as some of them do not have common file name. For today, I only uploaded the sample data only. I want to bring the files into the canvas using the batch macro. Please see attached file. Can you help me with this one pls? Note: This is a sample data only.

[DawnDuong]

Hi @dunkindonut7777 

Would like to clarify a couple of points:

- Do you want to read all the files without unzipping the zipped file? Or it's ok to unzip everything to a folder first before the reading them.

- By "input" do you mean to extract all the data into one single output file? Or something else?

- Do all the files have the same schema?

This is a fairly popular question and the good news is the community members have got some very good answers, check them out via the below links:

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

https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-Al...

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CS-Macro-Dev-Reading-in-Multiple-Fi...

Regards,
Dawn.