Import multiple zip files and export into multiple zip files

Question

I need to import multiple zip files. Each zip file has a single .tsv file. After importing all the zip files i need to do some basic transformation and then export each file back as .tsv and zip file. For Eg: import 6 zip files and export 6 zip files.

Tripati · Answer

Can anyone help me on this

danilang · Answer

Hi @Preet2020

One of the problems with using the Input tool to read zip files is that you have to know the name and relative path of the file within the zip archive of file you want to read.  If you know this you're good to go.  If you don't know or the file name changes from one archive to the next, you run into problems.

When we have to read dynamic zip files, we always start with the solution from @DavidM, found here.  It uses the Python  zipfile library to extract the file names from the archive and has the advantage of not relying on external tools to pre-extract files from the archive.

Dan

rafalolbert · Answer

Hi @Preet2020,

When I worked with zip files in the past I had to do it using the Command Line tool and invoke additional software like 7zip.

I believe the Download tool handles zips out of the box now, so this is your best place to start.

The best advice would be to develop a macro that handles 1x file end to end, so from zip, via the requirements of the transformation and back to zip and upload.

In the zip interaction is not with any web-based technology (this is where you would use the Download tool), you may need to use the above mentioned (Command Line Tool + 3rd party software).

Hope you resolve this quickly and gain some great time savings in this automation.

Thanks,

Rafal

#Excuse me, do you speak Alteryx?