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!
