Formula to reclassify a specific "Null" Value

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.

Data Investigation

Accepted answers

traceystone

Brilliant.. Thank you

All comments

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

Sample workflow 3105.yxmd

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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703