how to get data max of date and max of date -1 from folder using tfilelist

[RAJ6]

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_1 component 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_1 component and max of date - 1 (XYZ_20Jun2017.xlsx) for tfilelist_2 component.

[RAJ6]

Hi ciw1973

Thank you so much for your solution. It's working good.