Can I unzip a file within my workflow?

Hi,

I'm working on a project where the data source comes in daily as a zipped file. Is anybody able to show me how to unzip a file within my workflow? Alternatively, can I use a zip file within my workflow? I'm unsure if Alteryx would be able to work with that as an input when building out the workflow.

Any guidance is greatly appreciated!

Input

Accepted answers

Treyson

To anyone still following this. There was a little more to the process that we had to go through. We were able to answer the original question, which was, "Can we unzip a file with Alteryx?" Yes you can. You need to utilize command line. The links above show how to do that. We also worked through using the directory tool to find the unzipped folder and extract the files from that.

All comments

Treyson

Hello!

Here is an older thread on the topic that should get you where you want to go.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-Alteryx-unzip-a-file-as-part-of-the-workflow/td-p/10604

If you started with Alteryx in the last 3 or so years, this article mentioned in this thread was written by the guy who built Alteryx. So its some fun stuff.

nmitch

Hi!

Thank you, this thread looks like the answer to my question. However, I am having a difficult time understanding where I need to make changes to fit my use case? I'm relatively new to using Alteryx and am pretty lost trying to understand the workflow.

Attached the workflow I'm referencing from the previous thread.

DownloadAndExtractZips (2).yxmc

Treyson

Let's revisit this when you get back. I am unfamiliar with power automate, but I did some quick searching and it seems you can unzip with that tool. If you are already familiar with how it works, maybe having the process that saves the zip file also unzip it, might be a worthy solution as well.

nmitch

Happy Tuesday! I'm back from much needed vacation and would be happy to revisit this topic. I did some initial research to unzip files through Power Automate but it struggled to push the file to a shared drive.

Treyson

Siddhartha0207

Hi guys,

I am also working on something similar to this. Can you help me to execute the process.

Treyson

@Siddhartha0207 where are you at in the process?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703