Where not EXIST SQL in Alteryx

[herbert1682]

I have two tables I want to filter out table A that does not exist in table B

 This is the SQL 

Select * FROM Denials
WHERE NOT EXISTS
(
SELECT * FROM Exlusion_List
WHERE Exlusion_List.Code = Denials.RsnCode
)

[echuong1 · Accepted solution]

Are you trying to replicate this query in Alteryx or are you just trying to load the data in using that query? 

You can actually use your SQL select query in Designer in the input data tool. When you connect to the DB, use the SQL editor. 

If you are trying to replicate the query in Alteryx, you would import each of the tables separately, and then use a Join tool. Depending on which side you connect each input will determine where the data you're looking for will be. Essentially, the join tool will give you everything that is common in the J output, and the non-matching data will be in the L and R outputs.

Let me know if this helps!

[RolandSchubert · Accepted solution]

Hi @herbert1682 ,

in Alteryx, you would use a Join tool to select rows of Table 1 with a specific field value not present in Table 2.

I've attached a sample workflow. Let me know if it works for you.

Best,

Roland

[grazitti_sapna · Accepted solution]

Hi @herbert1682,

There are multiple ways to do it. Two of them are:

1)  You can use your SQL select query in Designer in the input data tool. When you connect to the DB, use the SQL editor to get the specified results.

2) You can use a join tool and make use of L port to get the records which are present in the 1st input but not in second input.

 The green highlighted portion should be your path.

I hope it helps.