Forum Discussion

deeave's avatar
deeave
Helper I
2 years ago
Solved

Merging Several Columns from 2 Different Tables to 1 Table

In my report, I would like one table that shows the title and status.  Data comes from two different tables.  When I attempt to use Merge Queries into new and select title in both tables, it brings o...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,

    Thanks for the solution asadmd93  offered, and i want to offer some more information for user to refer to.

    hello deeave , if you want to the same columns in two tables, you can refer to the follwing sample.

    Sample data 

    Table A

    Table B

    Create a blank query, then input the following code in advanced editor.

    let
    Columnname=List.Intersect({Table.ColumnNames(#"Table A"),Table.ColumnNames(#"Table B")}),
    Source1=Table.SelectColumns(#"Table A",Columnname),
    Source2=Table.SelectColumns(#"Table B",Columnname),
    Combine=Table.Combine({Source1, Source2})
in
    Combine

    Output

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi,

Thanks for the solution asadmd93  offered, and i want to offer some more information for user to refer to.

hello deeave , if you want to the same columns in two tables, you can refer to the follwing sample.

Sample data 

Table A

Table B

Create a blank query, then input the following code in advanced editor.

let
    Columnname=List.Intersect({Table.ColumnNames(#"Table A"),Table.ColumnNames(#"Table B")}),
    Source1=Table.SelectColumns(#"Table A",Columnname),
    Source2=Table.SelectColumns(#"Table B",Columnname),
    Combine=Table.Combine({Source1, Source2})
in
    Combine

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • deeave's avatar
    deeave
    Helper I
    2 years ago

    This worked perfectly to combine the tables, thank you!  I updated the code to create a table to identify the source table so I could display in my report.  Code below:

     

    let
    // Select the columns from Project_ideas and add SourceTable column
    Source1 = Table.AddColumn(
    Table.SelectColumns(Project_ideas, {"Service", "Status", "Title"}),
    "SourceTable",
    each "Project_ideas"
    ),

    // Select the columns from Project_Discovery and add SourceTable column
    Source2 = Table.AddColumn(
    Table.SelectColumns(Project_Discovery, {"Service", "Status", "Title"}),
    "SourceTable",
    each "Project_Discovery"
    ),

    // Combine the two tables
    CombinedTable = Table.Combine({Source1, Source2})
    in
    CombinedTable