Multiple files from Directory

Question

Read files from directory where there are close to 700+ files which has unique name for each file suffix with the Date, should consider only the latest available file ( going back upto 3 days from today) from the field where the date field is suffixed

sample

BARX_20250228.csv

BARX_20250303.csv

BARX_20250304.csv

BARX_20250305.csv

GHJ_20250303.csv

GHJ_20250304.csv

Using right function - got the date from the file name to new field  
 
using Right function separated the date to a new field

disub · Answer

sort tool picks file latest randomly but  not considering all the required files from the directory

caltang · Answer

You can sort the date and then use a Sample tool to select the first of x group's no. 1 row.

disub · Answer

used formula tool to bring the Date suffixed with the file name and converted to Date format & added Filter function " dateTimeDiff(DateTimeToday(),[DateTime_Out],'day')<=3 . Now on the "True" - it considers the latest 3 files from the list and on " False" the other backed dated file.
The next step is to consider the 1 latest file each from the "TRUE" function. How to make it consider 1 latest each file?