Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Get rid of some black list number from contacts file

Feras95p
8 - Asteroid

Dear all,

 

I'm looking to design a workflow that gets rid of the black list contacts from the orginal file by checking the black list contacts number fron black list file:-

 

For example I have two files the first file is the original file which contains the data of all contacts number, what I'm looking for is to remove from that file the numbers which exist in black list file.

 

Any idea how to achieve that?   

1 REPLY 1
DataNath
17 - Castor

@Feras95p one way would be to just conduct a join on the contact number. Any that join successfully (J output anchor) you can just ignore, and any coming out of the left (L/top) output anchor haven't matched and so you can carry on using these:

 

DataNath_0-1657151427061.pngDataNath_1-1657151436332.png

 

Would ignore these - joined successfully = blacklisted:

 

DataNath_2-1657151458430.png

 

Not joined - carry on using:

 

DataNath_3-1657151472214.png

 

Labels