dynamic input to read zip xlsm files

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.

Input

Accepted answers

grazitti_sapna

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.

All comments

grazitti_sapna

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.