IF statement to change data in one column depending on a second column

[MarkGi]

Hi

I think this should work but I guess I am missing something fairly basic in the syntax.

I have two columns with dept codes ie

Column 1:  Column 2:

TDD             111

TDA             123

TDB             133     

TDD             111

What I am trying to do is change the code in column 1 to a new code depending on the data in column2 .  So I have in the formula node -
Output Column set as Column1

IF [Column2] == '111' THEN [Column1] == 'TDX' ELSE [Column1] ENDIF 

So I should end up with 

Column 1:  Column 2:

TDX             111

TDA             123

TDB             133    

TDX             111

When I run it, instead of TDX I have a 0 returned for the 111 rows

Any suggestions would be very appreciated

[ed_hayter]

IF [Column2] = '111' THEN 'TDX' ELSE [Column1] ENDIF

I think should work assuming your column 2 is a string

[JamesCharnley]

@MarkGi 

When you're updating a column, you don't need to reference it again in the formula. The following should work if it's numerical, you just need to wrap the 111 in '' if it's a string.

[MarkGi]

Thanks - I thought it might be syntax.