Unknown Variable error

[Ctraore]

Hello,

I am using the Dynamic Rename tool to rename the "Fees Total Amount" field to the corresponding period fees. The goal is to have the Dynamic Rename tool look at the PERIOD field and take the corresponding value. So, in this example, it would be "PERIOD10 FEES". I tried using a regex or even an IF formula but I keep getting the error saying Unknown Variable "PERIOD" when the variable clearly exists. Is there a way to achieve this such that the value of the period is included in the new name?

Thank you for your assistance.

[binuacs · Accepted solution]

@Ctraore you cannot assign a field value to the field name using dynamic rename tool, use the transpose/cross tab tool for that