Dynamic Rename

[KateC]

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!

[atcodedog05 · Accepted solution]

Hi @KateC 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @KateC 

Cheers and have a nice day!

[KateC]

Thanks, @atcodedog05! You've saved me twice today. 🙂

[JaeLim]

Hi @KateC,

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

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

 

 
Hope this helps! 😊