Forum Discussion
Solved
M - Merge 2 tables within One query
Hello there,
I have 2 tables, that I can merge together, but wanted to know if and how to do this within 1 query by referencing the relevant steps in the query here is my code:
let
Place...
Yes, the 5th argument needs to be text and you reference the first step which returns a table. So wrap it into "" like so:
MergePlaceCodes= Table.NestedJoin(PromoStoresRenameColumns1 ,{"REPSLY CODE"},PlaceCodesSource ,{"REPLSY CODE"},"PlaceCodesSource" ,JoinKind.LeftOuter)
Yes, the 5th argument needs to be text and you reference the first step which returns a table. So wrap it into "" like so:
MergePlaceCodes= Table.NestedJoin(PromoStoresRenameColumns1 ,{"REPSLY CODE"},PlaceCodesSource ,{"REPLSY CODE"},"PlaceCodesSource" ,JoinKind.LeftOuter)