1 Reply Latest reply: Sep 9, 2016 6:25 AM by Rohit Kumar RSS

    Three tables associated together?

    josh flory

      I don't quite understand how to interpret this and I didn't have any luck tracking it down in the documentation.

       

      I think what happened was a many to many table, but I'm not sure.

       

      I have

       

      Customers
      CustomerAddresses
      CustomerOrders

       

      all three have CustomerID and all three tables seem to join together on a single dot in the middle.

       

      I sort of expected them to join THROUGH the Customers table so... I am not sure how to properly interpret this visualization of the data model?

       

      QlikSenseModel.PNG

        • Re: Three tables associated together?
          Rohit Kumar

          Hi Josh,

           

          Lets assume CustomerID has alias CustomerID in all table if not , You just need to like CID as CustomerID,CustID as CustomerID and load the data , How Qlik works, It joins tables on the basis of common name between tables. please make sure only 1 field as CustomerID is common among all the three tables.if not ,Change the name of other common field fields except CustomerID .

          .

          Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.