I'm currently working on a project which need to GET on a FTP the most recent file (Date in filename). Then convert XML to CSV, doing some formatting & PUT it back on FTP. All of this is done by now.
I do need now to delete the oldest file, using the same logic. My question sounds pretty easy but I would like to know if I can use a tricky way on my current project to do that, instead of recreate all the JOB since its just doing the opposite. Tho, i see no possible way to use tFileList sorting twice.
Here a screenshot of my current job, getting the new file & put it back, working good thanks to @manodwhb
Any idea is good to take, Thanks for your precious time
Solved! Go to Solution.
@manodwhb Thanks for you answer again.
How can I specify in the tFTPDelete to ONLY delete the oldest files tho? Because *.XML will delete all of my XML files.
Thanks for your help!
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.