The Inspire Cyber Monday promo has been extended to Dec. 1! This offer is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Maximum value from column names

8 - Asteroid

I am using dynamic rename, and i have for example columns

2020, 2021, 2022, 2023


Since the column names will be different every year, i want to choose MAX out of the numbers.

is there a formulaic way to do an if in dynamic rename that would rename a column based on the max value?

17 - Castor
17 - Castor

Hi @nataliad18 


Is it something like this you're looking for?


rename max field.png