Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Hi,
Thanks for your help.
Thank you for your help. I have found another solution.