Can Alteryx unzip a file as part of the workflow?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Stephen Ruhl
Principal Customer Support Engineer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Excellent!
Thank you James!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
And this should run just fine through the scheduler, should it not?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Found the answer to my own question: this wonderful workflow will run successfully through scheduler provided the alteryx server has 7-Zip software.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
update: used overwrite mode in 7-zip command - works! In case anyone is interested =)
https://sevenzip.osdn.jp/chm/cmdline/switches/overwrite.htm
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!