Load CSV file coming zipped with dynamic name

[vitorfc]

Hi Folks,

I am receiving weekly data in CSV format but it comes in a zip file named like this:

DATA_2018-12-03.zip

This zip contains a CSV file DATA_2018-12-03.csv

I want to schedule the workflow to run automatically and I tried to use the Dynamic Input or even the Run Command to unzip the file but couldn't make it run properly. 

Do you have any suggestions on this?

Thanks.

[DavidP · Accepted solution]

Have a look at this post that shows how to read data from zipped files. Hopefully it points you in the right direction.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-input-tool/m-p/321770#M58591

Also information here:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Inputting-data-from-a-zip-file/ta-p/25513

[vitorfc]

That worked perfectly. Thanks!

[DavidP]

You’re welcome. Feel free to mark it as a solution to help others on the community who are searching for solutions to similar problems.