dynamic input to read zip xlsm files

[Domo]

Hello all,

I'm trying to get atleryx to dynamic input multiple zipped files that contains xlsm files. I'm using the directory tool to bring back the file names and they files all the same format. I've done this before for zipped csv files and it worked successfully, but I get an error when I perform the same requirements for xlsm.

I get the error "Unable to open archive:"

Maybe I'm setting it up wrong. If it's possible, can anyone tell me how to set it up?

Thanks. 

[grazitti_sapna · Accepted solution]

Hi @Domo , Please try out the below link and let me know if it was useful to you.

https://help.alteryx.com/11.7/DataSources/ZipFiles.htm

If your problem is not resolved. Can you please share the files which you are trying to read in Alteryx. I can try out the workflow from my end.

[Domo]

Hi Sapna, Thanks. Attached is a test zipped xlsm file. There will be a number of these type of files in a folder, so I'll need to directory input to find the files and a dynamic input to read them.

[flying008]

Hi,@Domo 

Maybe you can use the macro [made by Felipe Alex Ribeiro ] in gallery for get your want:

********

If it can help you, please mark it as a solution and give a like for more share.

[Domo]

Hi Flying008, do you have the link. I couldn't find it on the gallery

[flying008]

Hi, @Domo 

FYI. Download Link: 

[Domo]

Thanks. This is macro brings back the file details which I can already capture. I need the dynamic input tool to read zipped xlsm files.

[flying008]

Hi, @Domo 

Yep, you need use 3rd tool unzip to get the .xlsm files to location first.