3 Replies Latest reply: Oct 21, 2014 7:03 AM by anbu cheliyan RSS

    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

        • Re: Duplicate keys when loading Input Field
          anbu cheliyan

          Can you post your script

            • 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

              [d:\DataSource\Excel\Sales\SALES20122014.xlsm]

              (ooxml, embedded labels, table is Sheet1);

               

               

              JOIN

               

               

              LOAD BUYER,

                   DATE,

                   BAMOUNT,

                   COMPANY,

                   MANAGER,

                   [TOTAL PLANNED CM],

                   [PLANNED SAH] AS BSAH

               

              FROM

              [d:\DataSource\Excel\Sales\BUDGET.xlsm]

              (ooxml, embedded labels, table is Sheet1);