Opening zipped files/folders within subdirectories

[D_Y]

Hi everyone

I have a bunch of zipped folders that are saved within a master parent folder called "Input". I drop off all these zipped folders into this Input folder on a monthly basis.

Within most of the zipped folders are .xls or .xlsx files - all of them contain the word "Summary".

I'm looking for a way to read the .xls and .xlsx files that are found within the zipped folders.

So far I tried using the Directory tool:

1. For the directory path I put the path to the Input parent folder

2. File specification, I put down "*Summary*"

However when I run the workflow there are no results at all. 

Looking for any assistance would be appreciated!

Thanks

[gabrielvilella · Accepted solution]

Hi @D_Y, using the Directory tool it is not possible to list files or folders from within a ZIP file. Please take a look at this article that shows a solution using Python. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Reading-Multiple-Files-Of-Your-Choice-... 

[D_Y]

Thanks @gabrielvilella !