INPUTFIELD [TOTAL VALUE AS PER ORDER];
CORE:
Load
[MERCHANDISING MANAGER]AS MANAGER,
BUYER,
[SEASON CODE],
[PHASE/BUY],
[TOP CATERGORIES],
GARMENTS,
[PACK CODE/DESCRIPTION],
PROGRAM,
RANGE,
[PRODUCT DESCRIPTION],
[ITEM CODE],
[PRODUCT CODE],
[COUNTRY CODE],
COUNTRY,
[MODE-ORIGINAL],
[MODE- REVISED],
PO,
ARTICLE,
[BUYER STYLE ID],
[PACK QTY],
[NO OF PACKS],
[ORDER QTY],
[ORDER QTY]/[NO OF PACKS] as PLANNEDPACKS,
[EX FACTORY ORIGINAL],
[EX FACTORY REVISED],
[IHOD/ACTUAL EX FACTORY],
[FOB PO DATE],
[REVISED FOB],
[CRD/VESSEL DATE],
[EX COUNTRY DATE],
[REVISED EX COUNTRY DATE],
NDC,
[SALES DATE]as DATE,
[SALES MONTH],
[FOB-PACK],
COMMISSION,
[FOB WITHOUT COMMISSION],
[TOTAL VALUE AS PER ORDER],
[SHIPPED QTY],
[SHIPPED QTY]/[NO OF PACKS] as SHIPPEDPACKS,
[SHIPMENT VALUE],
[INVOICE NO],
[QTY VARIANCE],
[SHIPPED STATUS],
[PLANNED SMV],
[PLANNED CM],
[PLANNED TOTAL VALUE],
[PLANNED CM/MINUTE],
[PLANNED SAH],
[SALES LOCATION],
[QTY FOR PRODUCTION LOCATION],
[QTY FOR SALES LOCATION],
[KGL-CM],
[TLD-CM],
[TAL-CM],
[PAN-CM],
[PRODUCTION QTY KGL],
[PRODUCTION QTY TLD],
[PRODUCTION QTY TAL],
[PRODUCTION QTY PAN],
[SHIPPED QTY KGL],
[SHIPPED QTY TLD],
[SHIPPED QTY TAL],
[SHIPPED QTY PAN]
From $(ExcelFile) (ooxml, embedded labels, table is [CORE]);
Next ExcelFile;
join
LOAD * INLINE [
SALES LOCATION, COMPANY
KGL, EMJAY
TLD, EMJAY
TAL, PENGUIN
PAN, PENGUIN
];
JOIN
LOAD * INLINE [
BUYER, COMPANY
BHS, EMJAY
BURTON, PENGUIN
CRAGHOPPERS, PENGUIN
DIESEL, EMJAY
GAP, PENGUIN
GAP/OLD NAVY, PENGUIN
GEORGE, PENGUIN
GEORGE O/W, PENGUIN
H&M, EMJAY
HELLY HANSEN, PENGUIN
HUGO BOSS, EMJAY
LA PERLA, EMJAY
LEVIS, EMJAY
M&S, PENGUIN
MERRELL, PENGUIN
OLD NAVY, PENGUIN
TESCO OW, EMJAY
TESCO UW, EMJAY
];
JOIN
LOAD COMPANY,
DATE,
BUYER,
[SHIPMENT VALUE],
BAMOUNT,
MANAGER,
[TOTAL CM],
[TOTAL PLANNED CM],
[ACTUAL SAH],
[PLANNED SAH] as BSAH
FROM
(ooxml, embedded labels, table is Sheet1);
JOIN
LOAD BUYER,
DATE,
BAMOUNT,
COMPANY,
MANAGER,
[TOTAL PLANNED CM],
[PLANNED SAH] AS BSAH
FROM
(ooxml, embedded labels, table is Sheet1);
