Free Trial

Alteryx Designer Desktop Discussions

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

Maximum value from column names

nataliad18
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?

1 REPLY 1
DavidP
17 - Castor
17 - Castor

Hi @nataliad18 

 

Is it something like this you're looking for?

 

rename max field.png

Labels
Top Solution Authors