Power Query Replace values through Merge

[absherzad]

Hi everyone,
I have two tables. Let us call them TableA and TableB.
I imported both of into Power Query as connection only query. Then I created a reference from TableA and Merged it with TableB using Left Outer Join Type.

Now I want to replace specific value for a column in TableA with value for a column from TableB for the matched records. What is the optimal approach of doing this?

Please see the Screenshot for better clarification.

 

[absherzad]

I have the following solution but I am afraid it is not the optimal one:

let
    Source = TableA,
    #"Merged Queries" = Table.NestedJoin(Source,{"Code"},TableB,{"Code"},"NewColumn",JoinKind.LeftOuter),
    #"Expanded NewColumn" = Table.ExpandTableColumn(#"Merged Queries", "NewColumn", {"Rank"}, {"NewColumn.Rank"}),
    #"Added Conditional Column" = Table.AddColumn(#"Expanded NewColumn", "MergedReplaced", each if [NewColumn.Rank] = null then [Rank] else [NewColumn.Rank] )
in
    #"Added Conditional Column"

 

[absherzad]

Here is another alternative solution for SQL users:

UPDATE TableA JOIN TableB USING (Code) SET TableA.Rank = TableB.Rank;