topic Re: Comparing the mtime of two tFTPFileProperties components in Talend Studio

Comparing the mtime of two tFTPFileProperties components

GMacLeod1633803101 — Fri, 15 Nov 2024 23:38:27 GMT

I have taken over support of a job which downloads files from a source FTP location, and transfers them to a target.

What I am trying to do is probably very simple when you know the product well.

I want to ensure that we only perform this transfer on files which are newer at source. I was thinking that if I could use two tFTPFileProperties components to get the mtime of the files on both source and target, I could compare these and then only process files where the source mtime is greater than the target mtime. I can't figure out how to compare the outputs of the two instances of the tFTPFileProperties components. tMap doesn't seem to want to accept more than one, same with tJoin.

Re: Comparing the mtime of two tFTPFileProperties components

Anonymous — Mon, 11 Oct 2021 01:45:43 GMT

Store the mtime value to context variable or global variable on tJavaRow for used in another subjob.

Regards

Shong

Re: Comparing the mtime of two tFTPFileProperties components

GMacLeod1633803101 — Tue, 12 Oct 2021 10:46:37 GMT

Thanks Shong. That's done the trick. Much appreciated!

What I did was ran a Main line from the tFTPFileProperties component to the tSetGlobalVar component. Worked a treat.