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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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

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