Opening zipped file without regular file extension

[mark22579]

I have a file that is sent from a vendor daily, but it got so large that it had to be zipped in order to for our internal transfer script to work.  This a text file but it doesn't have a regular file extension.  The naming convention is the same every day expect the last 8 digits which are the date that the file is sent (see example of zipped file path below).  There are several other files that are transferred into the same server folder, so I use a directory tool to select the proper file.  I've tried using a Dynamic Input tool to open the compressed file but keep getting error and I believe it's due to the file I've selected in the "Input Data Source Template". 

Below is a screenshot of my current input process/tool with a description of what each one is doing. 

My goal is to have a scheduled workflow open and process these files without manual intervention which is how the process worked before the files had to be zipped. 

[KGT]

I've found that inputting zip through Dynamic Input had some issues regarding the filenames inside not being the same each time, and my template file needing that option to be a part of the "template", if that makes sense. This is going off memory from a couple of years ago. The workaround would be a batch macro as you can then control all the options on the input tool.

It may take a little mucking around, but you would want to feed the filename (Orders20250813.zip for instance) in as the control parameter, and inside the batch macro, have that be the input tool (standard batch macro for input). You may however also need that control parameter to update an option in the "Table/Query" part of the input tool, to select the file to be extracted (assuming it is named Orders20250813.txt).

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309