Synthetic Key

MK_QSL — Wed, 28 Aug 2013 13:49:03 GMT

Hi Community....

Please help me to remove synthetic keys for below tables...

Purchase:
LOAD

%PG,
PurchaseSupplierID,
[Purchase Cost],
[Purchase Qty],
[Purchase Month],
PurchaseMonthName,
PurchaseQuarter,
[Purchase Year]
FROM

(qvd);

Inventory:
LOAD

%PrimeSupplierID,
[ECP NO],
%PG,
InventoryTotalValue,
InventoryTotalQty
FROM

(qvd);

SalesData:
LOAD

%PG,
%PrimeSupplierID,
[Sales Value],
[Cost Value],
[Qty Sold],
SalesMonth,
SalesMonthName,
SalesYear,
SalesQuarter
FROM

(qvd);

TitleMap:
Mapping Load
PM,
[PM Name]
FROM

(ooxml, embedded labels, table is PM);

PRODUCTGROUP:
LOAD

PC          as %PG,
PCNAME            as PGName,
DG1                  as [PGLevel 01],
DG1NAME          as [PGLevel 01 Name],
DG2                  as [PGLevel 02],
DG2NAME          as [PGLevel 02 Name],
PM,
ApplyMap('TitleMap',PM) as [PM NAME],
BM
FROM

(ooxml, embedded labels, table is PG);

Supplier:
LOAD

Supplier,
[Supplier Name]
FROM

(ooxml, embedded labels, table is Supplier);

Left Join (Purchase) Load *, Supplier as PurchaseSupplierID Resident Supplier;
Left Join (SalesData) Load *, Supplier as %PrimeSupplierID Resident Supplier;

Drop Table Supplier;

LostSale:
LOAD

[ECP NO],
%PG,
[Lost Qty],
[Lost Value]
FROM

(qvd);

Re: Synthetic Key

Andrea_Ghirardello — Wed, 28 Aug 2013 14:09:10 GMT

You need to create composite keys.

For more information see:

http://community.qlik.com/message/50060#50060

http://community.qlik.com/docs/DOC-1303

http://community.qlik.com/docs/DOC-4599

topic Synthetic Key in QlikView

Synthetic Key

Re: Synthetic Key