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 with condition

Hello, I need help to achieve this: some column names missed "0" at second letter, like PD56, I need to rename it to P0D56. example:
Meteor

@DataKiller  - Hope this helps !

Thanks! 

And can we add IF condition? because just some of column names are missed "0"

If length = 5, the column is correct. if not, need to add "0"

 

Meteor

Yes , I have updated the workflow to include that condition.

Thanks so much!!!

Hi, still have some problem when apply it to my *.csv format. I upload the file for asking your help.
Highlighted
Meteor

From this , it looks like you would like to row values to be reamed not COLUMN as per your initial post . This can be achieved using a formula tool , 

1) Drag the formula tool next to the input

 

2)select [I0D] under Output Column and add the below 

 

if length([I0D] )!=5 then
Substring([I0D],0,1)+"0"+Substring([I0D],1,Length([I0D]))
else
[I0D]
endif

Labels