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.
Solved! Go to 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,