Need help creating a new data field for customers starting with "zz"

Problem 1:

I have a customer list of internal and external customers. Data field "Customers".

Internal customers are denoted with a "zz" in the beginning of the name.

I want to create a new data field "Intercompany" which will show YES if "Customers" start with zz. NO for all others.

Problem 2:

Create a rolling mapping table which can automatically ensure customer names are consistent. For example, rename all customers containing "Facebook" into "META" and "Google" into "Alphabet". Also instead of using pre-defined formulas, can I use fuzzy logic?

Thanks!

Workflow

Datasets

Common Use Cases

Best Practices

Fuzzy Match

Accepted answers

All comments

binu_acs

@dareinnyc For problem 1 you can use the string function StartsWith()

IIF( StartsWith([Customers],'zz'),'Yes','No')

Problem2 - Use the Find and Replace tool for this use case

jfha97

The solution by @binu_acs works perfectly, I was going to suggest RegEx (because I've had more experience with it before Alteryx) but StartsWith gets the job done.