Formula to reclassify a specific "Null" Value

[traceystone]

Hello, Need some help with a formula in Alteryx. I have a set of suppliers that are labeled Null and the only way I can see who the supplier is by a notation in the line description. I am not sure how to write this. If the line description contains "Tangoe" then change the supplier name/customer name to Tangoe. 

[IraWatt]

Hey @traceystone,

Heres the formula you were looking for

IF Contains([Line Description],"Tangoe") THEN "Tangoe" ELSE [Supplier Name/Customer Name] ENDIF

However if you want a more dynamic solution does the company name always the first word in the description?

Any questions or issues please ask :)
HTH!
Ira

[traceystone]

Thank you.. That works but I do have a deeper question. I only want to rename the "Null" supplier. The formula is renaming the "Tangoe INC" supplier as well. I need to keep them separated. The "null" is actual monthly billing. Tangoe INC is the quarterly fees that the company charges for the monthly billing. 

[IraWatt]

This formula has a check if null then rename:

IF Contains([Line Description],"Tangoe") AND [Supplier Name/Customer Name] = NULL() THEN "Tangoe" ELSE [Supplier Name/Customer Name] ENDIF

[traceystone · Accepted solution]

Brilliant.. Thank you

[IraWatt]

No worries @traceystone ! :D make sure to green tick the answer too :)