Forum Discussion
Merge Columns from two tables into same column in master table
I have two Tables: Master and Mapping as below: Master Company Name Location A Houston B Dallas C D ...
Hi Anonymous
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.
danextian
Super User
Super UserHi Anonymous
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.