Pick xls file from zip file (dynamic names)

We have a folder containing day wise zip files (they are stored there everyday). Inside the zip files, there are multiple files of different formats. We want to pick an xls file from the zip file and use it as an input for a workflow. The names of the xls and zip files keep changing depending on the date.

Input

Accepted answers

OllieClarke

@akshay-dwivedi No need for macros or .bat files here.

You can use a dynamic input tool to input the .xls from the .zip, and then use a Date Time Now tool to update this with the current date.

Here's a really simple version

Hope that helps,

Ollie

excelfromzip.yxzp

All comments

OTrieger

@akshay-dwivedi
You can unzip it with Run Command into a given folder.
Connect that folder to Directory tool and define there which file type do you need.

As Alteryx not really supporting well XLS files, my next recommendation will be to get these file converted to xlsx for a smoother operation.

akshay-dwivedi

@OTrieger

Thanks for the reply. How do I make Alteryx extract zip files with a dynamic name everyday? If the date today is 21-Oct-2024, I will need the zip file with 241021 to be extracted and so on.

OTrieger

with the same logic, connect the folder where the zip will be to a directory file and then get the zip name from there.
After that you finished with your transformation, add one more run command to move all the files from the folder connected to the first directory so the next time when alteryx will unzip the files to that folder it will be empty.