Dynamic Rename

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!

Developer Tools

Accepted answers

atcodedog05

Hi @KateC

Here is how you can do it.

Workflow:

Hope this helps : )

last month.yxmd

All comments

atcodedog05

Hi @KateC

Here is how you can do it.

Workflow:

Hope this helps : )

last month.yxmd

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_]

Dynamic Rename.PNG

Hope this helps! 😊

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703