Start Free Trial

Alteryx Designer Desktop Discussions

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

can I remove prefix of a column using dynamic rename tool

Sshasnk
8 - Asteroid

I have a dataset and I want to remvoe the prefix of it 

 

Input:

filenameInput_nameamountInput_amount
xlsxalexalex100100

 

I want to replace Input_ from PY

 

output:

filenamePY nameamountPY amount
xlsxalexalex100100

 

 

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @Sshasnk you can do that using the Replace() function within an expression in the Dynamic Rename tool:

 

DataNath_0-1669631256291.png

 

Replace([_CurrentField_],'Input_','PY ')
binu_acs
21 - Polaris

@Sshasnk One way of doing this

binuacs_0-1669631408128.png

 

Labels
Top Solution Authors