How to add a column from a different table

[Anonymous]

Hi all, 

I have a simple question regarding Power Query. 

I am working on two tables. Tables have in common a column, and the link is made between the 2 tables. 

I'd like to add to table 1 a column of table 2, in PowerQuery. 

I cannot share my data since it is for business matt

[KNP · Accepted solution]

@Anonymous - If you prefer a visual representation of what @JamesRobson is describing...

[JamesRobson]

Hi,

 If i follow correctly you just want to merge the 2 tables and expand the column required

#"Merged Queries" = Table.NestedJoin(#"Renamed Columns", {"REP"}, PM_User, {"UserCode"}, "PM_User", JoinKind.LeftOuter),
#"Expanded PM_User" = Table.ExpandTableColumn(#"Merged Queries", "PM_User", {"UserName"}, {"PM_User.UserName"})

or

#"Merged Queries" = Table.NestedJoin(#"PreviousStepHere", {"Table1Column"}, Table2NameHere, {"Table2Column"}, "Table2NameHere", JoinKind.LeftOuter),
#"Expanded Table2NameHere" = Table.ExpandTableColumn(#"Merged Queries", "Table2NameHere", {"ColumnYouWantToAdd"}, {"ColumnYouWantToAdd"})

this would give you the column 'ColumnYouWantToAdd' from Table 2 added to Table 1