community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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. 

 

2017_12_01_Test_Dec_20172018_01_01_Test_Jan_20182018_02_01_Test_Feb_2018

 

 

Any suggestions.

 

Greatly appreciate your help.

 

Thank you
Mark

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! 

Labels