Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Can Alteryx unzip a file as part of the workflow?

Philip
12 - Quasar

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

 

40 REPLIES 40
jdunkerley79
ACE Emeritus
ACE Emeritus

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
Alteryx
Alteryx

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.

Regards,
Stephen Ruhl
Principal Customer Support Engineer

joannatg
7 - Meteor

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
ACE Emeritus
ACE Emeritus

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
7 - Meteor

Excellent! 

Thank you James!

joannatg
7 - Meteor

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

joannatg
7 - Meteor

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
6 - Meteoroid

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
6 - Meteoroid

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

 

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

 

Capture.JPG

 

 

asifk
8 - Asteroid

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!

Labels