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.

deaddingo's avatar
deaddingo
Regular Visitor
5 years ago

Hi ERD 

 

As these have been pulled direct from SFDC, would modifying the column names in Bi have any affect on this?  Also,  what would happen to the columns that are not the same in all the tables?


Thanks

ERD's avatar
ERD
Community Champion
5 years ago

deaddingo , I was talking about preparations in Power Query.

1. If you append the tables with the same column names, then you will get your summary table:

2. You can get rid of non mutial columns using Home tab - Choose Columns. Otherwise you will get null values for non mutial columns:

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