topic Re: Delete files older than 90 days in Talend Studio

Delete files older than 90 days

RRasti1603876642 — Wed, 28 Oct 2020 09:29:24 GMT

Hi everyone,

I need to delete the files from an archive folder which are older than 90 days. My job design is as follows:

tfilelist --> tfileproperties --> tmap --> tfilterrow --> tfiledelete.

in tmap, I'm using the diffdate function to get the difference between the current date and the mtime_string in days ("dd"). After this I need to put the logic to delete all the files which are older than 90 days, which I'm not able to. Please help!!

Re: Delete files older than 90 days

Anonymous — Wed, 04 Nov 2020 09:21:35 GMT

Hello,

Please try to design your work flow like:

tFileList---iterate-- > tFileProperties ---main--->tMap-------main--->tfileDelete

On tMap schema editor, you can use a condition to check mtime in expression

((TalendDate.getCurrentDate()).getTime() - (Long)row1.mtime) > (90 * 24 * 3600000) to delete files based on above condition.

Let us know if it works for you.

Best regards

Sabrina