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 the column in the query editor? Please can you tell me how to do this?

 

Thanks,

 

CM

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Anonymous

     

    In the edit query mode, you can try the Merged Queries to bring in data from other table. Similar to look up value using related.

     

    Try it out if you still have issues you can post back here.

     

    Cheers

     

    CheenuSing

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Anonymous CheenuSing - This suggestion is simple and effective. Thank you!

  • 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.