I have a requirement to change the name of the filename in a file-to-file scenario. The prefix of the file will stay the same, but the target file needs to have a date format replace main part of the file. The date format is also specific YYYYMM. Below are the two examples of the source and target filenames. We are not doing a message mapping with this scenario.
Source: CA_MONTHLY_REPORT.txt Target: CA_200901_01.txt
Source: US_MONTHLY_REPORT.txt Target: US_200901_01.txt
The date needs to be calculated off a date function for current month and year.
Is this possible to do?