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!
Solved! Go to Solution.
try using join tool.
By the time i am sharing workflow for same.