Specifying path to a zipped folder and reading all the .xlsx files compressed

[AbhishekMehta]

Hi All, 

I'm trying to specify the path of a .zip file through a Text Box in an Alteryx app and want to consolidate all the .xlsx files that are inside that zipped folder. (all of these .xlsx files have the same schema). I also would like to have a file name column in the consolidated data to identify the source. 

ZIP file path: C:\Users\abcd\Desktop\AlteryxFiles\Input.zip

Files inside: A.xlsx, B.xlsx

I would really appreciate all the help here.

Thanks

Abhishek 

[atcodedog05]

Hi @AbhishekMehta 

Here is how you can do it.

Step-1: Drag in a input and search for the Zip folder.

Step-2: Once you click on open you will get something like below.

Click open

If you have multiple sheets you will get option like below.

Once you click on Ok and run it. It will import all the data.

Workflow:

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍