Nani,
Your solution is both elegant and great, but I foresee one small issue if all the original data is as posted:
The formatting of the dates are not equal between the table and the file names, so the strings won’t match.
you need to include a strVariable.replace(“/”,“-”) to have successful matches.
Assign PayrollDate = (CurrentRow(“Payroll Date”).ToString.Trim).replace(“/”,“-”)