Morning awesome Alteryx community
I've got onequestion
What is the formula to use for the following scenario?
If title contains "trainee" or "assistant" or "contractor" then remove entire Excel row
Thanks in advance for your help
Hi @Tommaso83,
Use a filter tool with the following custom filter.
Contains(title,'trainee') or Contains(title,'assistant') or Contains(title,'contractor')
Your F anchor will remove all unwanted rows.
Best,
Fernando V.
Hi @Tommaso83 ,
As far as I am familiar with the Alteryx there is no such way of deleting the row or a column directly in alteryx but you can simply use filter tool to get the desired output. Here is the formula that you can use in the filter tool by changing its configuration to Custom.Contains([Title], "Trainee") orContains([Title], "Assistant") orContains([Title], "Contractor")
I hope this helps!
@Tommaso83 wrote: Morning awesome Alteryx communityI've got onequestionWhat is the formula to use for the following scenario?If title contains "trainee" or "assistant" or "contractor" then remove entire Excel rowThanks in advance for your help
Sorry for not explaining clearly.
I'm going to attach an example showing how.
Fernando Vizcaino
Thank you!!!
One more question:
How to write filter expression that removes anyone which last name contains only 1 letter or 1 letter with a dot (ex. A or A.)?
Thanks
