Forum Discussion

xjiang's avatar
xjiang
Frequent Visitor
7 years ago
Solved

Issue with using information from both tables after creating relationship

Hello all,   I need some help for a project that I have been working on,   I have 2 tables (A: 40 columns with the planning stats) (B: 48 columns with the actual stats). Each table has more than ...
Need Help
  • dedelman_clng's avatar
    dedelman_clng
    7 years ago

    Hi xjiang - 

     

    In Query Editor when you do "Merge Queries", you can match up the 7 columns that align between the two tables and use a "Left Outer" join to get all of the rows and columns from the Planning table, and all of the columns from the Actuals table that match up with a row in Planning, like so:

     

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Community Champion
7 years ago

Assuming you are doing Import (as opposed to DirectQuery - if you are using that others will need to help as I'm not familiar with it), in the Query Editor you go to Add Column -> Index Column -> From 1.  If you sort the tables in the same way prior to building the index the indexes should line up.

 

 

Hope this helps

David

xjiang's avatar
xjiang
Frequent Visitor
7 years ago

Hi David,

 

Thanks again!

 

Will this solution work if the 2 tables don't have the same number of rows? The actual stats table didn't included the plans in table A that got cancelled.

 

Thanks,

  • dedelman_clng's avatar
    dedelman_clng
    Community Champion
    7 years ago

    Hi xjiang - 

     

    In Query Editor when you do "Merge Queries", you can match up the 7 columns that align between the two tables and use a "Left Outer" join to get all of the rows and columns from the Planning table, and all of the columns from the Actuals table that match up with a row in Planning, like so:

     

     

    Hope this helps

    David