Filtering out values based on a separate file

[gabriellamccormick]

Hello all!

I am trying to use Alteryx to compile a large dataset, but I first need to filter out certain values from a different data set based on a VIN.

For example, the data set 1 looks something like this:

Data set 2 looks something like this:

I need to be able to keep all of the data from data set one but filter data set 1 for any VIN that do not show up in data set 2 i.e. I have to filter out VINs ABC and ABD from data set 1 and only leave VIN ABE.

Thanks!

[alexnajm]

A Join tool is your best bet! The L anchor coming out should be your single ABE record

[gabriellamccormick]

I thought the same thing! But when I do a left join, this is what the output looks like. The whole data set is null

[alexnajm]

It works for me... looks like you have no non-matches then in the data you are using