Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Honored Contributor III

Re: Duplicate keys when loading Input Field

Can you post your script

Not applicable

Re: Duplicate keys when loading Input Field

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
Honored Contributor III

Re: Duplicate keys when loading Input Field

Community Browser