Forum Discussion

mike_302's avatar
mike_302
Frequent Visitor
4 years ago
Solved

Merge Queries: Returns Column of "Table" Values?

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?

Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi mike_302 ,

     

    Click this button here:

     

    Then you can choose from a list which column(s) you want to be added to the base table via the merge.

     

    Pete

3 Replies

  • BA_Pete's avatar
    BA_Pete
    Icon for Super User rankSuper User
    4 years ago

    Hi mike_302 ,

     

    Click this button here:

     

    Then you can choose from a list which column(s) you want to be added to the base table via the merge.

     

    Pete

    • mike_302's avatar
      mike_302
      Frequent Visitor
      4 years ago

      Cheers! I've done that now and it's served the purpose. I guess I was expecting there to be a way to do that within the merge step, perhaps making things more efficient, but I don't care too much 🙂 Objective achieved.

      • BA_Pete's avatar
        BA_Pete
        Icon for Super User rankSuper User
        4 years ago

        mike_302 

         

        No worries, glad it's sorted 🙂

        The merge/expand steps are separated so you can perform calculations/transformations etc. on the nested tables before you expand.

         

        Pete