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

[Divyajyothi7]

try this formula

IF CONTAINS([#1], "Report: Daily Revenue Retail for") THEN
"Date"
ELSE
[#1]
ENDIF

[apathetichell · Accepted solution]

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.

[KamenRider]

Thanks @apathetichell . It works.

Kamen