Merge Columns from two tables into same column in master table

[arikofather]

I have two Tables:  Master and Mapping  as below:

Master
	Company Name	Location
	A		Houston
	B		Dallas
	C
	D
Mapping
	Company Name	Location
	C		Austin
	D		San Antonio
Result
Master
	Company Name		Location
	A		Houston
	B		Dallas
	C		Austin
	D		San Antonio

Using Query editor I wany to update Location column in table Master with Location in table Mapping where Company Name and Location exist in table Mapping.    Bear in mind there are hundreds of rows in my live tables.   These are just samples.

Is this possible in Query editor and how?

[danextian · Accepted solution]

Hi @arikofather 

In the query editor merge Master with Mapping on Location columns from both.

After expanding add another column to coalesce between the two columns. The custom column will return the first non-null value so if you want Location from Mapping takes precedence, it should be the first column.