Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

IF Statement for beginner

Tommaso83
Alteryx Alumni (Retired)

Hi Everyone

 

Completely new here.

Trying to build my first workflow and missing some basics

 

I would need help for 3 formulas:

 

1) FORMULA n.1: if mobile number starts with +, then replace + with 00

2) FORMULA n.2: if company is "ABC" then create email address firstname.lastname@abc.co.uk

3) FORMULA n.3: if last name contains added msc, then remove msc (example: if last name is Smith msc, then keep only Smith)

 

Thank you for your help 😉

13 REPLIES 13
jacob_kahn
12 - Quasar

Sure @Tommaso83 

 

Happy to assist a newbie to the Alteryx community!

 

So what I might do something in the attached workflow very quickly.

 

I'm sure you can do this in the formula tool and can try for you if you prefer

 

Thanks,

 

J

jacob_kahn
12 - Quasar

@Tommaso83 

 

You can refer here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Replacing-multiple-values-in-one-strin... and here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-make-two-Replace-function-in-on... for more information on replace multiple string values.

 

The RegEx solution just allows it to be dynamic, so that you don't actually have to specify all of the possibilities.

 

J

Tommaso83
Alteryx Alumni (Retired)

Morning awesome Alteryx community

 

I've got another question

 

What is the formula to use for the following scenario?

 

If title contains "trainee" or "assistant" or "contractor" then remove entire row

 

Thanks in advance for your help

KilianL
Alteryx Alumni (Retired)

2) FORMULA n.2: if company is "ABC" then create email address firstname.lastname@abc.co.uk

 

I guess you need a generic solution for this for any company name?

 

Use a formula tool to create the email like this:

 

solution1.png

 

 

Labels