Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
There's still time to register for the Q3 ACE Panel - Spatial Edition presentation tomorrow! | Need more information about the event? Check out the post here
SOLVED

IF Statement for beginner

Highlighted
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

Highlighted
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

Highlighted
Alteryx
Alteryx

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

Highlighted
Alteryx
Alteryx

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