Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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.

Tags (1)
Community Browser