File to File with no mapping (different filename)

[Former Member]

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?

Thanks

Skip Ford

[Former Member]

.

[Former Member]

HI Skip,

I think, you should be able to get the YYYYMM as a part of the file name using OS command in the file adapter.

Thanks,

Pooja Pandey

[Former Member]

With mapping (UDF) it is easy. But I guess you're not allowed to use mapping, you would need to introduce adapter module.

I think with the standard configuration, you can not archive it. You have to use either UDF or adapter module.

Jayson