Syn Key problem

Mon, 08 Apr 2013 12:00:43 GMT

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.

topic Syn Key problem in QlikView

Syn Key problem