Dynamic Input error using ZIP Files from the Directory Tool

Hi Community,

Every day a get a system generated zip file ( It contains 1 csv file) which I save into a specific location on my C Drive

I was then going into the Workflow and manually and repointing the WF to the latest Zip file. But I'd like to use the Directory tool to do this. Can some please help me?

Getting this error when creating the Directory steps:

Error: Dynamic Input (110): Unable to open archive: C:\Users\kspratt\Documents\Colm Murphy\Rainer Project\1. Alteryx Files\PSH_xxascp_supply_demand_extract_report_4289289.zip

Like I say there is a CSV file with the actual data in this ZIP, and I want the dynamic to always run the WF on the latest ZIP FIle we save down.

Sample of the Directory Paths are in Excel file

TIA,

Karl.

ZIP Files Examples.xlsx

Workflow

Accepted answers

MatthiasSeil

When looking at your workflow it seems that the filepath for the csv is not considered yet but only the one for the zip. Also the csv needs the full filename.

When it is a general rule that the .zip file has the same filename than the .csv as in your example we can take this info from the directory tool output, replace ".zip." with ".csv" and then use this as the new filepath.

I've attached my revised WF once more.

Hope this helps.

Cheers

Matthias

csv-zip-Input.yxmd

All comments

MatthiasSeil

For getting the .csv out of the .zip, you need to add the name of the csv to the full path with ||| (same procedure as with Excel Sheets - see screenshots).

Use Dynamic Input and Select zip as a file type, next use a formula tool in order to extend the full path with the csv filename. Set the Dynamic Rename to "Replace with entire File path".

For always taking the last zip file from the folder you could sort by creation date (as you already do) and then just sample the first record (see wf attached).

Hope this helps.

Cheers

Matthias

csv-zip-Input.yxmd

Karl_Spratt

Hi Matthias,

Still getting an error, my ZIP files all contain a CSV as explained but each day they get a different number appended to the end of the zip / csv, example today's file was xxascp_supply_demand_extract_report_4289536.zip and it is

xxascp_supply_demand_extract_report_4289536.csv but tomorrow's file might be xxascp_supply_demand_extract_report_42899999.zip etc.

Error message is:

Error: Dynamic Input (142): Unable to open archive: C:\Users\kspratt\Documents\Colm Murphy\Rainer Project\1. Alteryx Files\xxascp_supply_demand_extract_report_4289536.zip

Attached my Directory part of the WF up to Dynamic Input.

TIA Karl

Directory Tool.yxmd

carolslsacramento

Hey Matthias, I know this is an old topic but I'm struggling to import zip files as well.

I've tried to replicate the solution you proposed, but it's not working. I suspect that has something to do with how the file was compressed, it seems like it is inside several folders (see the attached image).

Cheers,

Carolina.

philiphongkp

Any resolution on the above? Running into issues which I suspect is due to trying to open a .TXT file.

apathetichell

two reasons:

1) dynamic input tool is not particularly dynamic - ie use a batch macro.

2) out of the box support for zip files is blah. If you are not sure of your zip file name - check out my macro on my github here - https://github.com/apathetichell/2024_AlteryxMacros

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703