Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.