This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a use case where I can't download the zip files. We are reading directly (using Alteryx Designer) from the zip file which has multiple files with same schema (but different data sets). I need to know how we can get the file creation dates of the files that are in the zip file.
If the zip file has 4 'csv' files, how would I get the file creation date and time so that I can figure out which is the oldest file and which is the newest. The Directory tool doesn't work as it will provide me date/time for only the zip file. I actually need the date/time for the files within the zip files.
@pankajk - based on my experience the Input tool can only read one csv file at a time from any given zip file (which contains multiple csv files).
In terms of a solution, one approach I can think of is to run a batch command (via Run Command tool) and unzip the zip file into its individual csv components (reference link). Then use the Directory tool to identify the file that suits your criteria and read it. Let us know if this wont work in your case.