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

[dareinnyc]

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!

[binuacs]

@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 @binuacs works perfectly, I was going to suggest RegEx (because I've had more experience with it before Alteryx) but StartsWith gets the job done. 

Thank you for teaching me more about Alteryx formulas!

[dareinnyc]

Thanks! I used this

if(startswith([Client],'zz'),'Yes','No')

Came back with 

Error: Formula (16): Parse Error at char(28): Malformed If Statement (Expression #1)

Where did I go wrong? 

[nagakavyasri]

@dareinnyc  try this

[binuacs]

@dareinnyc your formula starting with IF, but it should be IIF