How to

[sallyarmstrong]

I'm new to Alteryx and I'm trying to determine if what I want to do is actually possible. I've watched so many videos and read so many forums but still can't figure this out. Any help would be much appreciated!

I've made an example table below as there's a few things I want to do:

(1) I want to eliminate rows where [Manager Last Name] is not contained in [Manager Email]. For example, for Project A, I want to remove the emails for jason.trane@email.com and anna.strong@email.com but keep the email for Ron Smith because he is the Manager listed on Project A.

(2) However, I do not want to remove the rows where [Manager Last Name] and [Manager Email] are blank. For example, I want to keep the row for Project B because I need the information for [Director Full Name].

(3) Lastly, I want to remove any duplicate rows. For example, I want to remove one of the rows for Project B and one for Project C. The duplicate can be removed. 

Project	Director Full Name	Manager Full Name	Manager Last Name	Manager Email
Project A	Ryan Johnson	Ron Smith	Smith	jason.trane@email.com
Project A	Ryan Johnson	Ron Smith	Smith	anna.strong@email.com
Project A	Ryan Johnson	Ron Smith	Smith	ron.smith@email.com
Project B	Susan Neil
Project B	Susan Neil
Project C	John Martin	John Martin	Martin	john.martin@email.com
Project C	John Martin	John Martin	Martin	john.martin@email.com

Thank you to anyone who is able to help!

[MilindG]

@sallyarmstrong See if this works

[binuacs]

@sallyarmstrong One way of doing this by applying the filter conditions 

[geraldo]

@sallyarmstrong 

You can use this filter

[Matt_Davis]

I did the same as @geraldo but used the 1 to denote case insensitive instead of the upper case, either works and then just select on Project or Project/Director in the Unique Tool.

[RobertOdera]

Hi, @sallyarmstrong 

Welcome to Alteryx😎

Kindly consider the below - I hope you find it helpful. Cheers!