Hi I have two tables Table 1's first two columns: IDNameA1Old Alpha A2Bravo Charlie Old Delta Table 2's first two columns: IDNameA2BravoA1New 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: IDNameA1New Alpha A2Bravo 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!

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

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!

Join

Accepted answers

MilindG

Okay, see if this works.

empty_join_sample.yxmd

All comments

MilindG

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

empty_join_sample.yxmd

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

Okay, see if this works.

empty_join_sample.yxmd

D_Y

Thank you!

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167