Exclude email based on domains list

[tjamal1]

Hello

I have two list , fist is called OfficeEmails which contains emails , and the second list contains list of domains which are not allowed 

Based on the 2nd List I want pick only those emails which dont have any block domain 

This is my 2nd List for reference 

• null@
• phish@
• phishing@
• postmaster@
• privacy@
• registrar@
• root@
• security@
• spam@
• support@
• sysadmin@
• tech@

How can i do this in Alteryx? 

[JosephSerpis · Accepted solution]

Hi @tjamal1 I mocked up an example that can do this? Let me know what you think?

[tjamal1]

Thanks , That worked for me 🙂