Retrieving the last csv file from an FTP server

[Kaliana]

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.

[JSey]

Hi

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.

[Kaliana]

Hi,

Thanks for your help.

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