Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Merging Queries and then Pivoting?

I have two tables (Table 1 and Table 2) from the same Excel file into Power BI. This Excel file is updated weekly. What I've been trying to do--I am not sure if I'm going about it the right way-- is ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  Anonymous ,

    According to the test, when you refresh in Excel, both your original table A and original table B will be refreshed, and the new table AB formed by combining the original table A and the original table B will also be refreshed.

    And P_A and P_B formed by Pivoting will also refresh the data, and the merge of P_A and P_B into a new table P_AB will also be refreshed.

     

    If you want to keep all related rows of the Table1Value and Table2Value columns, you can use the JoinKind method of Full Outer in the merge to keep it.

     

    Both the merging and pivoting steps are implemented after the data is loaded.

     

    Best Regards,

    Liu Yang

    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
5 years ago

Hi  Anonymous ,

According to the test, when you refresh in Excel, both your original table A and original table B will be refreshed, and the new table AB formed by combining the original table A and the original table B will also be refreshed.

And P_A and P_B formed by Pivoting will also refresh the data, and the merge of P_A and P_B into a new table P_AB will also be refreshed.

 

If you want to keep all related rows of the Table1Value and Table2Value columns, you can use the JoinKind method of Full Outer in the merge to keep it.

 

Both the merging and pivoting steps are implemented after the data is loaded.

 

Best Regards,

Liu Yang

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