Table.CombineColumns - Query Editor

Hi

As you said, you want to combine from these 3 tables only specific columns in a new table but to do it in the Query Editor instead of using DAX function “ union and selectedcolumns”.

Here is a simple example to do this.

Select the first two columns from each table of the three tables(eg. From excel)  and add them into a new table.

Table1

Table2

Table3

New Table

In query editor, New Source>Blank Query, code in advanced editor,

let
    Source1 = Table1,
    Source2 = Table2,
    Source3 = Table3,
    AppendColumns1=Table.SelectColumns(Source1, {"columnA","columnB"}),
    AppendColumns2=Table.SelectColumns(Source2, {"columnC","columnD"}),
    AppendColumns3=Table.SelectColumns(Source3, {"columnE","columnF"}),
    RenameAppendColumns2 = Table.RenameColumns(AppendColumns2,{{"columnC", "columnA"}, {"columnD", "columnB"}}),
    RenameAppendColumns3 = Table.RenameColumns(AppendColumns3,{{"columnE", "columnA"}, {"columnF", "columnB"}}), 
    #"Appended Query1" = Table.Combine({AppendColumns1, RenameAppendColumns2}),
    #"Appended Query2" = Table.Combine({#"Appended Query1", RenameAppendColumns3})
in
    #"Appended Query2"

Best Regards

Maggie