I am trying to download the zipped file at the below link but am having trouble with the regular expression in the RegEx tool. Any suggestions would be greatly appreciated.
I found a discussion with a similar issue but the link that they were using does not work so I cannot use it as an example to see how they pulled the expression. Attached is the workflow I have so far.
Solved! Go to Solution.
Hi @grodriguez
It is possible, one way is by using this macro. Take a look at it. I need to go for now, but tomorrow i send you the workflow with this macro working.
https://community.alteryx.com/t5/Community-Gallery/Unzip-zip-and-yxzp-files/ta-p/1161434
Hi @grodriguez
See this version, it will download the current month file, unzip it and import the xlsx to the workflow.
Wow that's awesome! Thank you so much for all your help. If I run this on the server will it require installing something for the unzip tool on the server?
@grodriguez no it should not require any further configuration The server just need to have access to the folders that you are dealing with (OUTPUTPATH).
But deploying to server can bring surprises sometimes, so try and be sure.
Does this need a temp location or folder location to download the files?