Starts with formula help

[binsell]

Hi All - I know this is a simple formula but for some reason Alteryx is not picking it up! I have checked and my course code column is a string data type so not sure what I'm doing wrong. I have attached my data before and after so can see what I'm trying to achieve. I have a course code column and if the course code START WITH 'TT' I want to return 'NITE' and any others leave as blank. Thank you for your help in advance :) 

[alexnajm · Accepted solution]

IF StartsWith([Course Code], “TT”) THEN “NITE” ELSE Null() ENDIF

[alexnajm]

What part is not working on your end?

[binsell]

Thanks Alex, when I type the 'THEN' it doesn't pick this part of the formula up so anything after then is not working :( This is the formula I originally did but doesn't like it :( 

[binsell]

Ignore that, I have just deleted the formula tool and done it again and now likes it! Thank you so much 

[alexnajm]

Happy to help