Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Related column look up in query editor

Hi,   I know in the table view I can use the RELATED function to effectively do a vlookup into another table. But I need this column to be available in the query editor so I think I need to create ...
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Have you tried the solution provided by Anonymous above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

 

If you still have any question on this issue, feel free to post here. :smileyhappy:

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi AnonymousCheenuSing - thank you that works but my 2 source tables are very large so I have to then delete a lot of columns after the merge. Is there a way to define exactly which columns I want to merge when creating the merge query?

     

    Thanks,

     

    CM

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      When merging you should only get a single new column in the new table.

       

      In that column, in the upper right corner click the expand icon and select which columns you want to include from your merge.