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?
Is it something like this you're looking for?