Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to 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.
Proud to be a Super User!
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.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
86 | |
64 | |
63 | |
60 |