I’m prototyping an ETL process and would like to grab the date & time of unzipped files using the “File Meta Info” node, however, the “Unzip Files” node changes the original timestamp. Are there ways to workaround this behavior? If not, I would love to have a checkbox to keep or not the original timestamp within the “Unzip Files” node options dialog.
Thank you in advance!
and welcome to KNIME Community!1
There is no workaround for Unzip Files node. However you could use External Tool (Labs) node to do this with command/script which will preserve original timestamp. Check also provided example on same link.
Additionally I have opened up a ticket to implement this option. (Internal reference: AP-15436)
Thank you very much! I will evaluate the indicated node and I’m also thinking about using a Python snippet.
here is an example how to use R to unzip data. There might be a setting that would allow to keep the original dates.
What about something like this and bring it back together. Extract the original date from the zipfiles.
@caiocco I checked the R unzip command and it offers the possibility to keep the original date and time stamp. You could check out this example here (you would have to download the whole workflow group).
Wow, mlauber71! Thank you again! I will test the workflow as soon as possible!
You are welcome. You will have to install R and connect it to KNIME. I have a meta collection to help you with that.
so seems there are couple of workarounds
Nice one with List Files node @Daniel_Weikert
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.