Forum Discussion

BogdanP's avatar
BogdanP
Frequent Visitor
10 years ago
Solved

Merging two data tables

Hello everyone, I am very new to PowerBI, so apologies if my question is too dumb.

Consider following data structure:

 

 As you can see, there are 3 lookup tables and 2 data tables. Set of Producers in "Import" table is slightly different than in "V" table. Apart from that these two tables are almost identical. 

 

So what exactly am I trying to achieve here? I want to create a single data table, containing following columns: "Producer", "Date", "Dimension", "Volume" and "Import". Appending queries didn't work because it duplicates producers, so merging queries is presumably the way to approach it. However, I was unable to achieve desired result.

 

Thank you in advance, any help is appreciated.

Need Help
  • RafDelgado's avatar
    RafDelgado
    10 years ago

    Hey Bogdan, 

     

     

    You have the relationships showing so you can still make a single visual table using the related information from the 2 data tables. If you really need a single table, what join kind are you trying on the merge? Could you not match the two table columns, merge and remove all the duplicates?

     

    Thanks,

     

    Raf

2 Replies

  • RafDelgado's avatar
    RafDelgado
    Helper II
    10 years ago

    Hey Bogdan, 

     

     

    You have the relationships showing so you can still make a single visual table using the related information from the 2 data tables. If you really need a single table, what join kind are you trying on the merge? Could you not match the two table columns, merge and remove all the duplicates?

     

    Thanks,

     

    Raf

    • BogdanP's avatar
      BogdanP
      Frequent Visitor
      10 years ago

      Hey Raf,

       

      Thank you for your answer. It pushed me in the right direction - have to admit that i completely forgot that PowerBI has "remove duplicates" feature similar to Excel one. So appending these tables and then clearing the duplicates worked for me really well. Thank you once more.