Renaming Header - Removing Date

KamenRider

Hi guys,

I have this header "Report: Daily Revenue Retail for 6/19/2024". I used the dynamic rename to rename this header and it works however, it gives an error every time I update my input file. The reason of the error is because the date update to 6/20/2024 and so forth. This is a daily report. Is there a way we can do to allow updating the input file without causing an error?  I would like to rename the header to "Date".

Below is the configuration i used for dynamic rename.

Thanks and hoping to hear from anyone.

Kamen

apathetichell

in you dynamic rename - you have to select your fields to change. You'd want to select your current date field (the 6/19 field in your picture) and select the dynamic/unknown fields checkbox at the end of your list. Then you will apply your logic to all new fields.