community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Can Alteryx unzip a file as part of the workflow?

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.

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
Customer Support Engineer

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?

 

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

Meteor

Excellent! 

Thank you James!

Meteor

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

Meteor

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

Highlighted
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...

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

 

 

Alteryx Partner

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