if then else to create new column

Question

My input data is

PositionLength231242

I want to create another column which should be

PositionLengthColumn231 24225

if the length is "2", then it has to take this column "Position" and add 1. If it is 1, then leave it blank

I tried using if the clause, but i'm getting an error(Type mismatch in operator "+")

IF [length] = "2" THEN [position] + "1"
ELSE Null()
ENDIF

Can someone pls help me fix this?

Thanks!

MarqueeCrew · Accepted Answer

Did you try...

IF [length] = 2 THEN [position] + 1
ELSE Null()
ENDIF

WillTravelForData · Accepted Answer

I used the formula

IF [Length]=2 THEN [Position]+1 ELSE Null() ENDIF

in the attached workflow to populate the new column.