Power Query. Merged 2 tables, but after renaming column name from 2nd table, expand column does not select this renamed column

[martinli]

Hi,

I have two tables, Table 1 and Table 2.

INDEX	Sex	Age
0	M	10
1	F	10
2	M	12

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

INDEX	Name	School
0	Tom	Test
1	Mary	Test1
2	Tommy	Test

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

I merged the two tables into Marge1

INDEX	Sex	Age	Name	School
0	M	10	Tom	Test
1	F	10	Mary	Test1
2	M	12	Tommy	Test

<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>

If i rename Table 2 column heading from School to test, the Merge does not display this renamed column. Is there an easy solution for this?

Thanks in advance.

 

[martinli]

After trying a couple of things i came up with the following:


let
Source = Table.NestedJoin(Table1,{"INDEX"},Table2,{"INDEX"},"NewColumn",JoinKind.FullOuter),
#"Expanded NewColumn" = Table.ExpandTableColumn(Source, "NewColumn", List.Difference(Table.ColumnNames(Table2), {"INDEX"}))
in
#"Expanded NewColumn"



I basically tell the table not to select the "INDEX" from the second table. Kind of a hassle but it works.