Merge Queries: Returns Column of "Table" items? I only want one of the columns.

[mike_302]

See the above Merge queries settings. I want the "Code" column to be merged into the OCLCA_Import_Sheet table, based on the common column, RICS NRM Category.

With the settings as seen above, The result is:

The "Table" item in each row is both the columns from the Tbl_RICSNRMCat dataset. I only want the Code column merged. How can I achieve this?

 

[RoryA]

Click the button on the top right of the column and choose which columns you want.