Can Alteryx unzip a file as part of the workflow?

[Philip]

I'm downloading climate data and the files come zipped. Can Alteryx unzip the files as part of the workflow?

The path to one of the files is

http://www.ncdc.noaa.gov/orders/qclcd/QCLCD201601.zip

[jdunkerley79 · Accepted solution]

Yep had a field limited to 30 characters, have upped it to 2000.

For reference found by pressing Ctrl-F and going to tool 30.

Also published on the Gallery 

https://gallery.alteryx.com/#!app/DownloadAndExtractZips/56a7dc323df7da0740bac48d

Let me know if this works for you.

[StephenR]

I'm just adding a comment to mention that reading zipped files is now part of Alteryx 11 since this thread comes up in Google searches.

[joannatg]

Your macro is very effective, thanks!

My zipped files are password encrypted and I would like to know if there`s a way incorporate the password into the .bat file so that the process is 100 % automated and I don`t need to input the password manually when prompted.

How could I accomplish that?

[jdunkerley79 · Accepted solution]

You can add a -pSECRET argument into the command built in the formula tool

This page https://www.dotnetperls.com/7-zip-examples has all the various command line arguments you can use

[joannatg]

Excellent! 

Thank you James!

[joannatg]

And this should run just fine through the scheduler, should it not?

[joannatg]

Found the answer to my own question: this wonderful workflow will run successfully through scheduler provided the alteryx server has 7-Zip software.

[ck_dup_428]

I am having some problems unzipping to a folder where the same file name exists (the workflows runs to about 78% then takes so long I manually stop it) - is it possible to always overwrite?

Thanks in advance...

[ck_dup_428]

update: used overwrite mode in 7-zip command - works! In case anyone is interested =)

https://sevenzip.osdn.jp/chm/cmdline/switches/overwrite.htm

[asifk]

Hi ace

When I try to run the macro, I receive the following error on Run Command (3)  "Error: Run Command (3): Error opening C:\Users\AsifKazi\AppData\Local\Temp\Engine_17892_b835fe52c189438980c054fc934dc0cd_\ziplist.txt: no fields found."

And according to my workflow zip.bat and move.bat is created but not ziplist.txt

Many thanks!