This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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
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.
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
2) FORMULA n.2: if company is "ABC" then create email address email@example.com
I guess you need a generic solution for this for any company name?
Use a formula tool to create the email like this: