Alteryx Designer Desktop Discussions

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

Dynamic Rename

KateC
Asteroide

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 RESPUESTAS 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
Asteroide

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! 😊

Etiquetas
Autores con mayor cantidad de soluciones