topic Re: Three tables associated together? in Connectivity & Data Prep

Three tables associated together?

Thu, 08 Sep 2016 14:47:41 GMT

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?

Re: Three tables associated together?

Fri, 09 Sep 2016 10:25:44 GMT

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.