Read the file present in the zip folder.

Question

Hi All,

I have a file which is present in the zip folder. But I can't read the file present inside the zip folder.

I can't use the 7 zip not allowed.

I have a daily zip folder coming (.zip format).  Which I want to read , and extract the inside file daily from it.

I have added the folder and file properties images.

The below is the file present in the zip folder which I want to read.  I have also added the type of the file.

If you can help me to read this file, inside the zip folder. I tried to pull the zip folder directly into the designer but due to no file extension it didn't show up.

caltang · Answer

DavidP's explanation here is apt: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Opening-and-reading-Zip-file/m-p/633672

Does this help?

For more info on Zip support, check out Alteryx's official documentation: https://help.alteryx.com/20231/designer/zip-file-support

Dhruv_001 · Answer

@geraldo Thanks for taking a look. Yes the zip folder and the file name present inside is same I have attached a sample along with it. Thanks

Well the file doesn't have the format. But I can read it as flat file individually after extracting out of the folder. So, I believe it's the text format.

06062023_File.zip

geraldo · Answer

@Dhruv_001

read the zip file or alteryx it reads. but need more information about the format of the internal file and also if the name of the zip is the same as the internal file to automate this reading