Forum Discussion

DFoster_22's avatar
DFoster_22
Regular Visitor
4 years ago
Solved

Merging Queries

Hi there,

 

So I'm trying to merge two tables that have a similar "Event Name" column, but not all the values in the Event Name column are identical. See Table 1 and Table 2 below. 

I am trying to combine these two tables so that they roll up together and give me the table that is shown below. 

I have tried merging queries using a Full Outer join kind but that only joins the rows that have similar values in both tables 1 and 2. I have also tried appending the tables and then using the Group By feature and selecting All Rows under the type of operation, but this is not working either. Any ideas on how I can combine tables with a similar but not identical columns?

 

Thanks.

Need Help

2 Replies

  • mahenkj2's avatar
    mahenkj2
    Solution Sage
    4 years ago

    Hi DFoster_22 ,

     

    I can't test now, but try as below:

    For each table, at first bring A to G column in one column by unpivot function in power query.

    Then append both.

    And then pivot the resultant appended table.

     

    Check if it works.