Related column look up in query editor

[CloudMonkey]

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

[sajju113]

Thank you! @CheenuSing 

[v-ljerr-msft]

Hi @CloudMonkey,

Have you tried the solution provided by @CheenuSing 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. 

Regards

[CloudMonkey]

Hi @CheenuSingCheenuSing - 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]

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.

[CheenuSing]

Hi @CloudMonkey

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]

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

---