Hello,
i have a problem wiht a syn key that qlikview generate automatically.
I have 3 tables: Dealers, Customers and Orders.
One customer is associate with your Assigend Dealer and one Order is associate wiht one customer and one dealer ( the dealer is not the same that the assigned to the customer).
My ETL is:
Dealers:
LOAD *,
Dealer ID as DealerCode;
SQL Select * from Dealers;
Customers:
LOAD *,
CustomerID as CustomerCode,
Dealer ID as DealerCode;
SQL Select * from Customers;
Orders:
LOAD *,
OrderID as OrderCode,
CustomerID as CustomerCode,
Dealer ID as DealerCode;
SQL Select * from Orders;
when i reload the data qlikview gerete a syn key with CustomerCode and DealerCode. This is a problem beacuse the syn key is not correct: the couple CustomerCode ad DealerCode are different in the table Customers and Orders.
How can i resolve this case ?
Thank you.