Duplicate keys when loading Input Field

Tue, 21 Oct 2014 10:25:12 GMT

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

Jayanthan

Re: Duplicate keys when loading Input Field

anbu1984 — Tue, 21 Oct 2014 10:37:04 GMT

Can you post your script

Re: Duplicate keys when loading Input Field

Tue, 21 Oct 2014 10:40:37 GMT

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

Re: Duplicate keys when loading Input Field

anbu1984 — Tue, 21 Oct 2014 11:03:31 GMT

Try Distinct

Duplicate key and the Inputfield

topic Re: Duplicate keys when loading Input Field in QlikView

Duplicate keys when loading Input Field

Re: Duplicate keys when loading Input Field

Re: Duplicate keys when loading Input Field

Re: Duplicate keys when loading Input Field