Cross-check one database against another

[eleee3]

Hi there,

I have two databases (main and dictionary), and I want to check that all the classes in my main database are listed in my dictionary. An example of how the main database looks is:

Car Description	Manufacturer Code	Model
Car No. 1	TY	Corolla
Car No. 2	MZ	CX-5
Car No. 3	VV	XC-90
Car No. 4	MT	El Grande
Car No. 5	VW	Golf

And an example of the dictionary database looks like this:

Manufacturer Code	Description	Manufacturer Code	Description	Manufacturer Code	Description
TY	Toyota	MZ	Mazda	TS	Tesla
VV	Volvo	MT	Mitsubishi	RR	Rolls Royce

So I want Alteryx to look at the Manufacturer Code column in my main database and check it against the three Manufacturer Code columns in my dictionary database. If there's a Manufacturer Code in my main database that doesn't appear in my dictionary database, I want it (and the associated information - car description, make, etc.) to be pulled into a separate spreadsheet.

So using the above as an example, as "VW" appears in my main database but not my dictionary database, I want the output to be:

Car Description	Manufacturer Code	Model
Car No. 5	VW	Golf

Could someone please help me set this up?

Thanks in advance!

[Raj]

try using join tool.

By the time i am sharing workflow for same.

[Raj]

find the solution attached

[ShankerV · Accepted solution]

Hi @eleee3 

One way of doing this!!!

Many thanks

Shanker V

[eleee3]

Thank you both very much, @Raj and @ShankerV !