Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Join tables based on multiple columns

Hi,   I have two tables . PowerBI does not let me join these tables as they do have unique values in one of the columns. In SQL I would join these tables based on two columns.    Table 1   acco...
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    Hey,

     

    in the query editor

    1. duplicate the columns that you want to use for the join
    2. mark the duplicated columns you want to use for the join, choose "Merge columns" from the context menu.

    Here is a screenshot:

     

    Repeat this for the 2nd table.

     

    Now you are able to use this column to create a relationship between both tables

     

    Don't forget to "hide" this column from report view.

     

    Hopefully this answers your question

     

    Regards

    Tom

     

TomMartens's avatar
TomMartens
Super User
8 years ago

Hey,

 

in the query editor

  1. duplicate the columns that you want to use for the join
  2. mark the duplicated columns you want to use for the join, choose "Merge columns" from the context menu.

Here is a screenshot:

 

Repeat this for the 2nd table.

 

Now you are able to use this column to create a relationship between both tables

 

Don't forget to "hide" this column from report view.

 

Hopefully this answers your question

 

Regards

Tom

 

pwc_ananta's avatar
pwc_ananta
Helper I
4 years ago

TomMartens 

Thanks for guiding.

Can you please tell me how will we design Incremental load with Merged Query.

In my case, I have to join tables with outer joins, I can't done it with concatenation, If I join the tables in merge query, than how I manage the Last_Updated_Date.

Should I create the Reference of tables and than merge the referenced queries using merge query and configure the incremental load on the original loaded tables? 

What is the correct way to do it?