Forum Discussion

deaddingo's avatar
deaddingo
Regular Visitor
5 years ago
Solved

VLOOKUP based off different tables

Hi All   Apologies if this type of thing has been asked numerous times, but i am struggling a bit with it.   I have numerous tables set up in a data model.   Some are being pulled from SFDC Repor...
Need Help
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi deaddingo ,

     

    As long as they have the same column names, they can be appended successfully.

     

    If the column names are different, let me give you an example. If I renamed the Status in the ROD table to Status 1, the following effects will appear.

     

    Then right-click the column name to sort, the results are as follows

     

     

    You just select append query as new. If it is not right, just delete the newly appeared table.

     

    Best Regards,

    Stephen Tao

     

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

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

The three tables on the left should be appended in the query editor in Power BI (or Excel), since they have the same columns.  You can disable load on them so they are not part of your model, but you can then load the new table and the one on the right and relate them, or you can first merge them in the query editor to have just one table to load.

Pat

 

  • deaddingo's avatar
    deaddingo
    Regular Visitor
    5 years ago

    Unfortunately the 3 tables don't all have the same columns in them.   The examples were just a very simplified version so I cant append.