Adding Specific Word

[quims]

Hi Alteryx Community,

Would like to check on what tool can be use if i want to add a value/word if a criteria met.

Sample: If [Cr/Dr] is equal to "Cr" then [Ref-A] will add a suffix word "Credits" else do nothing.

Thanks in advance.

[Thableaus · Accepted solution]

Hi @quims 

Add a Formula Tool.

Select your [Ref-No] Column or Create a New Column

Expression:

IF [Cr/Dr] = "Cr"

THEN [Ref-No] + " Credits"

ELSE [Ref-No] ENDIF

Cheers,

[quims]

Wow! that was so fast! it is working perfectly.

Thanks for the help, @Thableaus