0 Replies Latest reply: Apr 8, 2013 8:00 AM by Alessandro Perozzo RSS

    Syn Key problem

      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.