Getting TimeStamp

[HanhDo]

Hi everyone,
I used CSV reader node to read a csv file which is regularly updated every 2 days.

And I would like to get that update date of the csv file and add into the output table as a column “TimeStamp” with format ‘%Y-%m-%d %H:%M:%S’.

Could you please advise me how to do so?
Thanks a lot for your help
Hanh

[knimediger]

@HanhDo

I assume that you are talking about the timestamp of the file creation.
AFAIK it is not possible to get this information directly. But there might be a workaround

How to get File Creation date of hdfs file

HI, I am using hdfs connection node to pull remote files list using List Remote files node. But the file Properties like creation date, modified date doesnt get extracted. Is there any node which can help extraction this information alongside the current URI. Thanks. JM

[HanhDo]

Hi @knimediger ,
I am actually talking about the timestamp of the csv file. For example, the csv file was updated latest on 2021-03-05 21:30:15 and I load it to KNIME on 2021-03-08 14:30:15. The timestamp I would like to get is 2021-03-05 21:30:15
I hope KNIME has something to support this.
Hanh

[kowisoft]

Hi HanhDo,

you can, there is in fact a dedicated node to it, the FIles/Folders Metadata node.

I have created a small example for you. What I did was to write the filepath in an empty table, convert it to data type of path and then extract the meta info through the aforementioned path.

See this mini workflow:

31256-getting-time-stamp – kowisoft

[HanhDo]

ahhhhh, I got it.
Thank you so so much for your kind help @kowisoft
Best
Hanh