can I remove prefix of a column using dynamic rename tool

Sshasnk

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

Input:

file	name	Input_name	amount	Input_amount
xlsx	alex	alex	100	100

I want to replace Input_ from PY

output:

file	name	PY name	amount	PY amount
xlsx	alex	alex	100	100

DataNath

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

Replace([_CurrentField_],'Input_','PY ')

Dynamic rename for Input_ prefix.yxmd