Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Duplicate keys when loading Input Field

Hi All

when i  try to include input field in script , following error message pops up, appreciate if you could help me to solve this issue

Duplicate keys when loading Input Field

BR

Jayanthan

3 Replies
anbu1984
Master III
Master III

Can you post your script

Not applicable
Author

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

anbu1984
Master III
Master III