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 |
Hey @Sshasnk you can do that using the Replace() function within an expression in the Dynamic Rename tool:
Replace([_CurrentField_],'Input_','PY ')