Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Run Command Tool: Zipping Files

taylormgruendel
7 - Meteor

Hi All!

 

I'm looking to zip up several files. I created a workflow to run a batch file through the run command tool. It produces a zipped folder but when I try opening it, I get the following error - 

 

zipping.png

 

I attached the folder containing my workflow, batch file, and data. Any thoughts on how to solve this? Thank you!

5 REPLIES 5
caltang
17 - Castor
17 - Castor

Heh, I ran into the same issue:

image.pngimage.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
caltang
17 - Castor
17 - Castor

lol through trial and error I got it to work:

image.png

 

The difference was here:

image.png

 

As per markcurry:

7z" a -tzip "Folder to store zip file" "folder to retrieve file to zip" 

 

He used: '7z a -t7z "C:\Temp\output.zip" "C:\Temp\output.csv"'

 

I used: '7z a -t7z "C:\Users\Calvin Tang\Desktop\Zip Use Case\Output" "C:\Users\Calvin Tang\Desktop\Zip Use Case\Input"'

 

Notice how I didn't declare the output.zip and also the output.csv.... it generated a file in itself.

 

Try and see! Generate the .bat file inside Alteryx and experiment with leaving both sides empty...

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
caltang
17 - Castor
17 - Castor

Some more pics:

image.pngimage.pngimage.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
VidyaKav
5 - Atom

Hello All,

 

I am trying to zip a file created in alteryx(csv) but none of the options work. I dont have 7z installed on my system and cant install it.

I am on windows 10, any suggestions to zip the file in any other will be helpful!

Thanks!

Labels