This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's difficult to say without seeing your workflow, but Is it not possible to do all you calculations first and rename the columns in the final step of your workflow?
Alternatively, if your incoming data has the year in the field names, you could use the Multi Field Tool and [_CurrentField_] variable to rename you columns so that you can have standard formulas and do the same at the end to insert the year in the field name.
That makes sense. My woorklfow is rreasobaly large with several inputs coming from different databases which have the year in their field name. I think my best solution would be to put a dynamic rename to remove the date from the field name after the connect In-DBa nd Datat stream out then I can just keep the names general in the formulas.