Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Exclude email based on domains list

tjamal1
8 - Asteroid

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? 

2 REPLIES 2
JosephSerpis
17 - Castor
17 - Castor

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

tjamal1
8 - Asteroid

Thanks , That worked for me 🙂 

Labels