The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. Learn more here!

Alteryx Designer Desktop Discussions

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

Dynamic Rename

KateC
8 - Asteroid

I did this in another workflow the other day, didn't need it, and deleted it. And now I can't find the post that helped me get there in the first place so...

 

I have a column "Billy/Bob" and every month I want to dynamically change that column header to include a date, for example, February 2022 (Billy/Bob). It needs to be the previous month, so when I run this workflow on March 1, the header needs to say February. 

 

Help me Alteryx Community, you're my only hope!

 

Thanks!

 

 

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @KateC 

 

Here is how you can do it.

Workflow:

atcodedog05_0-1644348513851.png

 

Hope this helps : )

 

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @KateC 

Cheers and have a nice day!

KateC
8 - Asteroid

Thanks, @atcodedog05! You've saved me twice today. ðŸ™‚

JaeLim
Alteryx Alumni (Retired)

Hi @KateC,

The Dynamic Rename tool should be able to achieve this, formula is as such:

DateTimeFormat(DatetimeAdd(DateTimeNow(),-1,'month'),"%b %Y") + ' ' + [_CurrentField_]

 

Dynamic Rename.PNG

 
Hope this helps! ðŸ˜Š

Labels
Top Solution Authors