Solved! Go to Solution.
@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"
Thanks so much!!!
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