Cast your vote for the official 2025 Inspire Pin! Designs were submitted by fellow Community members and reflect the creativity and passion of Alteryx users across the globe. Vote now!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
解決済み

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!

 

 

4件の返信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
アステロイド

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

ラベル
トップのソリューション投稿者