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);
