Xlookup or Vlookup equivalent in Alteryx

[rjesus1987]

Hello Team,

With the sample tables below,  what's the best tool I need to use to achieve my goal.  I Tried using Join Tool but can't really achieve the output that I need.

Goal: Match Supervisor ID and L1 ID.  Result should show under New L1_Name

Sample Table:

Table 1

ID	Employee Name	Supervisor ID	Supervisor Name	New L1 Name
1	John	7	John Doe
2	Mike	8	Mike Jordan
3	Anne	9	Anne Hat
4	John	7	John Doe
5	Mike	8	Mike Jordan
6	Anne	9	Anne Hat

Table 2

L1 ID	L1 Name
7	Johnny Doe
8	Michael Jordan
9	Anne Hathaway

[alexnajm]

Why does the join tool not work in this case? that’s exactly what I would use

[rjesus1987]

Hello,

Apologies for the confusion.  I need to match Supervisor ID and ID using Employee Name as a "Lookup Array" and result should appear under new L1 Name.

Below is the updated table:

ID	Employee Name	Supervisor ID	Supervisor Name	New L1 Name
1	John	7	John Doe
2	Mike	8	Mike Jordan
3	Anne	9	Anne Hat
4	Jane	7	John Doe
5	Michelle	8	Mike Jordan
6	Ana	9	Anne Hat
7	Johnny Doe	10	Harry Potter
8	Michael Jordan	11	John Snow
9	Anne Hathaway	12	Beyonce Knowles

Output:

ID	Employee Name	Supervisor ID	Supervisor Name	New L1 Name
1	John	7	John Doe	Johnny Doe
2	Mike	8	Mike Jordan	Michael Jordan
3	Anne	9	Anne Hat	Anne Hathaway
4	Jane	7	John Doe	Johnny Doe
5	Michelle	8	Mike Jordan	Michael Jordan
6	Ana	9	Anne Hat	Anne Hathaway
7	Johnny Doe	10	Harry Potter	null
8	Michael Jordan	11	John Snow	null
9	Anne Hathaway	12	Beyonce Knowles	null

[alexnajm · Accepted solution]

You would still use a Join tool - however, you would also add a Union afterwards and bring in the J and the L anchors to replicate a "left Outer Join". That will keep all the records from the first data set if there is a match or not a match