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.

Anonymous's avatar
Anonymous
Not applicable
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

Thanks Stephen (and everyone for their replies).

 

I will give this a try.

 

Appreicate the help.