Replacing values in one table with values in another table, with some values being empty

[D_Y]

Hi

I have two tables

Table 1's first two columns:

ID	Name
A1	Old Alpha
A2	Bravo
	Charlie
	Old Delta

Table 2's first two columns:

ID	Name
A2	Bravo
A1	New Alpha
	New Delta
	Charlie

I would like to update the "Name" column of Table 1 with the "Name" column of Table 2 by looking up the ID.

New Table 1 that I am looking for:

ID	Name
A1	New Alpha
A2	Bravo
	Charlie
	New Delta

Normally I would think that a simple Join tool would be enough to do this type of Vlookup. However, the empty IDs are throwing me off. I'm not sure how to make my workflow more flexible so that it can also take into consideration the empty IDs. 

Appreciate any help with this!

[MilindG]

You can perhaps use union after the join to fix the issue. Check out the workflow.

[D_Y]

Thank you for your help @MilindG ! Sorry, one thing that came to mind that I didn't account for was that Table 1 has some rows that do not exist in Table 2. Those rows are to be kept as well. For example, take a look at A3 - Echo below. 

Table 1 Before:

ID	Name
A1	Old Alpha
A2	Bravo
	Charlie
	Old Delta
A3	Echo

Table 2:

ID	Name
A2	Bravo
A1	New Alpha
	New Delta
	Charlie

Table 1 After:

ID	Name
A1	New Alpha
A2	Bravo
	Charlie
	New Delta
A3	Echo

I tried to add the L anchor to the Union tool of your workflow, but not unfortunately that in itself doesn't work. 

[MilindG · Accepted solution]

Okay, see if this works.

[D_Y]

Thank you!