Forum Discussion
Merging Queries with two inner joins
Hi, I'm trying to merge two queries, but I need to do inner joins on two different columns in each query. When I use the query editor, I can only merge on a single column. Can I merge on two co...
You may join on any number of columns. If in user interface, select two columns in first table, two columns in second table, and join.
If you merge tables, that will be like
= Table.NestedJoin(Table1, {"A", "B"}, Table2, {"X", "Y"}, "Table2", JoinKind.Inner)If use Table.Join when
= Table.Join(Table1, {"A", "B"}, Table2, {"X", "Y"}, JoinKind.Inner)You may google for all parameters.