Extracting the contents of the zip file (accessing the modified date of the csv file)

[T_Alter]

I was testing the directory tool to access the last modified date of a csv file contained in a zip file. I found the last modified date of the zip file, not the date/time of the csv file in the zip file. I am looking for the date and time for the files within the zip files. I attached a screenshot of a .csv file that contains the modified date that I am looking for.

I am new to Alteryx designer, so I am open to suggestions.

[DavidP]

Hi @T_Alter 

Unfortunately, I don't think Alteryx can do that. I played around with a few example files and got the same result as you did.

Here is the help documentation on zipped file support in Alteryx

https://help.alteryx.com/20214/designer/zip-file-support

[TheOC]

hey @T_Alter 

If you're comfortable with Python, this route might be worth taking:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Get-File-creation-date-from-files-with...

Cheers,
TheOC

[TheOC]

forgot to add - you can embed this into Alteryx Designer by using the Python tool. 
Cheers,
TheOC

[T_Alter]

I haven't used Python in a while, but I will see what this is about.

[TheOC]

If you run into any issues, do give me a shout!

Cheers,
TheOC