1). Associations creation in Qlikview:
Tables not having common key, then create a common key to make association between tables.
Ex:
Customer:
LOAD * Inline [
CustID, CustomerName
1, Luke
2, Leia
3, Chewbacca
4, Han Solo
];
Orders:
LOAD * Inline [
OrderID, CustomerID, Product, QTY
11234, 4, Fedora Hat, 1
12234, 2, Hair Brush, 1
13234, 3, Breath Mints, 10
14234, 1, Light Sabre, 1
];
NewOrder:
LOAD *, CustomerID as CustID
RESIDENT Orders;
DROP TABLE Orders;
Load data, Now Customer and NewOrder table having an auto Assosiation with CustId column.
2). Auto Associations between tables in qlikview:
Field names must be exactly the same for auto-association links between tables.
Ex:
Customer:
Load
CustId,
CustName
From Customer.xlsx;
Orders:
Load
OrderId,
CustId,
OrderDetails
From Order.xlsx;
Load data, Now both tables having common key as CustId, so it'll form Auto Association between tables.
3. Synthetic Keys in Qlikview:
More fields with common names form Synthetic keys and a new Synthetic table with common names.
Ex:
Customer:
Load
CustId,
OrderId
CustName
From Customer.xlsx;
Orders:
Load
OrderId,
CustId,
OrderDetails
From Order.xlsx;
Load Data, Now both tables are having two common names as CustId,OrderId, so it creates an Extra table with common names. Clear this issue with rename, qualify, unqualify options.
