Forum Discussion
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 ...
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
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.