Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sample:
LOAD
DealerCode as %link1,
PartNumber & PartDesc as %link2,
DealerCode,
DealerName,
BranchName,
AREAOFFICE,
ZONE,
Code,
Category,
[Main Dealer Code],
ChassisNo,
MODELCODE,
ModelDesc,
CurrentKMReading,
EngineHrs,
IsUnderSWarranty,
DIVISON,
SaleDate,
RoNumber,
ROOpeningDate,
[RO TIme],
SrvTypeDesc,
CustomerCode,
CustomerName,
PartNumber,
PartDesc,
Category.1,
Platform,
[landedcost/PC],
Qty,
BasicValue,
[Landed cost],
Profit,
[% Profit],
BillableType,
[BILABLE TYPE],
INVOICENO,
INVOICEDATE,
[INVOICE TIME],
MRP,
NDP,
sheet
FROM
[C:\Users\a2z\Downloads\Test file.xlsx]
(ooxml, embedded labels, table is [1.2 Parts sale & Profitability ]);
Outstading:
LOAD
[Customer- CCA],
SubField([Customer- CCA], '-', 1) AS DealerCode,
DealerCode as %link1,
Customer,
Name,
City,
[Area Office],
State,
Zone,
Category as Category_out,
Remark,
[Credit Control Area],
CCA,
[Credit Limit],
Outstanding,
Balance,
[30-Mar-22],
[06-Apr-22],
[13-Apr-22],
[20-Apr-22],
[29-Apr-22],
RTGS,
[WARRANTY CREDIT]
//DealerCode & Category as Link1
FROM
[C:\Users\a2z\Downloads\Test file.xlsx]
(ooxml, embedded labels, table is [4.Outstading and aging Report]);
Here two fields are matched and Systhnices keys are formed how to created link table or else another other option suggest