how to get data max of date and max of date -1 from folder using tfilelist
Hi Talend Folks,
I have files like XYZ_17Jun2017.xlsx, XYZ_18Jun2017.xlsx, XYZ_19Jun2017.xlsx, XYZ_20Jun2017.xlsx.
for example:
I need to get max of date(XYZ_20Jun2017.xlsx) file from folder using tfilelist_1component and max of date - 1 (XYZ_19Jun2017.xlsx) for tfilelist_2 component.
I need to create job below like screenshots.
It is a routine process
Next day automatically i need to get max of date(XYZ_21Jun2017.xlsx) file from folder using tfilelist_1component and max of date - 1 (XYZ_20Jun2017.xlsx) for tfilelist_2 component.