topic Re: Retrieving the last csv file from an FTP server in Talend Studio

Retrieving the last csv file from an FTP server

Kaliana — Sat, 16 Nov 2024 00:39:03 GMT

Hello,

Can you help me please?

I need to get the last D-1 file from an FTP server (sort the file into folders by year and month) then insert the data into our oracle server.

So We just need the file j-1 so for today, we must retrieve the file: RPT.STR.KM.CSV.24-20210208-24-STR.FUELSENSOR

Thanks for your help.

Re: Retrieving the last csv file from an FTP server

JSey — Wed, 10 Feb 2021 02:28:46 GMT

You can use a tfilelist component to create a mask for the filenames, then you can order it by filename or modified date. If the tfile list component is in a different subjob than your tfileinputdelimited, then it will only process the last file, which will be the last file if you sort it by date ascending.

Re: Retrieving the last csv file from an FTP server

Kaliana — Mon, 15 Feb 2021 11:16:14 GMT

Hi,

Thanks for your help.

Thank you for your help. I have found another solution.