Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Dynamic Rename - Remove prefix using "%" wildcard?

Is there any way for dynamic rename tool to apply a wild-card?


In a cross-tab output, I want the date columns to be sorted hence I prefix the date. But in the end, I want to dynamically rename columns to remove the prefix "_Test_%" (i.e. remove all strings preceding "_Test_" so only Dec_2017, Jan_2018, so on remain as column names. 





Any suggestions.


Greatly appreciate your help.


Thank you

Alteryx Certified Partner
Alteryx Certified Partner

Since the prefix string is a set length, you could just remove the first 16 characters of the names.


Dynamic Rename Formula: 

substring([_CurrentField_],16) or right([_CurrentField_],8)




Thank you Charlie S, it works!