nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Preparation

Accepted answers

jdunkerley79

The post @chris_love refers gives you a lot of detail on how to do this.

I have done this in the past using a Download Tool to get zips and save to temp files and then a Run Command to extract the zip files.

The main trick I used is to create a batch file of all the downloaded zip names and then read in a directory list to get back the filename list.

Have attached my workflow (downlaods from TurtleTrader.com but can easily be changed). I use 7Zip and the formula tool needs the path to this to create the commands.

Hope it helps

DownloadAndExtractZips.yxmd

jdunkerley79

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.

DownloadAndExtractZips.yxmc

jdunkerley79

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

All comments

chris_love

Yes. A good place to start would be looking at the technical details of
this post by Ned:

http://inspiringingenuity.net/2013/08/21/alteryx-reading-xlsx-directly/

jdunkerley79

The post @chris_love refers gives you a lot of detail on how to do this.

I have done this in the past using a Download Tool to get zips and save to temp files and then a Run Command to extract the zip files.

The main trick I used is to create a batch file of all the downloaded zip names and then read in a directory list to get back the filename list.

Have attached my workflow (downlaods from TurtleTrader.com but can easily be changed). I use 7Zip and the formula tool needs the path to this to create the commands.

Hope it helps

DownloadAndExtractZips.yxmd

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15907

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703