15 Replies Latest reply: Nov 5, 2015 7:07 AM by Nayan Lalla RSS

    Linking 2 Tables to form 1 table

    Nayan Lalla

       

      Hi

       

       

       

      I have 2 tables , a, Transactions table and a Sales Persons table , as shown below. The common field between the 2 tables is the Document number.

       

      I am uncertain how to merge the 2 tables so that in my table viewer i want to see 1 table. 

       

       

       

      I have attached

       

      • the QV Model ,
      • The data in  excel
      • a Screen shot of the table viewer.  This is showing the 2 tables linked by the document number.  However I want to achieve only 1 table.



        Please can you help.



        Thank you .

        

       

       

      Transactions Table
      DocumentCustomerValue
      1A200
      2B500
      3C300
      4D200
      5E300

       

       

       

      Sales Person Table
      DocumentSales Person
      1Dave
      2John
      3Mike
      4Dave
      5Gary