In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Reading in .7z files

JHetherington
5 - Atom

Hi

 

I have a received a number of .csv files that have been zipped as .7z.

 

Is there a tool/macro/workflow that can read these in please? I've had no success using the regular input data tool. 

 

Thanks

John

2 REPLIES 2
JaeLim
Alteryx Alumni (Retired)

Hi @JHetherington ,

You should be able to find the answers within this thread:


https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Can-Alteryx-unzip-a-file-as-part-of-th...

To tackle password protected zipped files, there is guide where you may need to add a -pSECRET argument into the command built within the formula tool.

JHetherington
5 - Atom

Hi

 

Thanks for the reply, though I can't find a specific answer in there about just reading in a 7z file (unless I am missing something obvious).

 

I've attached a csv. If anyone can help with a workflow that will read this into alteryx (after it has been zipped to a .7z file) then that would be much appreciated, thanks.

 

Tried to upload as a .7z file, but it's not a supported file type.

 

John

 

Labels
Top Solution Authors