please help - Error : duplicate keys when loading input field

[#1]

Get "duplicate keys when loading input field" when I try to load this. Please help

INPUTFIELD Jan, Feb , Mar , Apr , May , Jun , Jul , Aug , Sep , Oct , Nov , Dec;

forecast:

LOAD //[Project_Code],

           Year & '\' & [Cost Centre] as KeyField,

           applymap  ('CostRateMap',[Cost Centre] & [Year],'unknown') as CostRates,

           applymap  ('CostRateMap',[Cost Centre] & [Year],'unknown') as SellOutRates,

[Task Code] ,

[User_Name] ,

     [Year] ,

     [Jan] ,

     [Feb] ,

     [Mar] ,

     [Apr] ,

     [May] ,

     [Jun] ,

     [Jul] , 

     [Aug] ,

     [Sep] ,

     [Oct] ,

     [Nov] ,

     [Dec]

FROM

D:\Live\$(vProjectCode).qvd (qvd)

;

[fosuzuki]

Have you tried to use LOAD DISTINCT?

[#3]

Hi Fernando

Thanks for your suggestion. The script went pass the INPUT stage but crashes after load "Execution of script failed. Reload old data?

Any other suggestion is welcome.

[#4]

I have just tried the same script but loading it from a extract of the QVD into Excel and it works. However, it doesnt work when loading the  QVD itself! How annoying!!! Please help as our preference is to load it from the QVD.

[fosuzuki]

Hi, can you post some sample files demonstrating the errors?

[#6]

Hi There

Thanks for your help.

Kind Regards

Max Aibangbee

Business Systems Analyst

VEGA Space Ltd

2 Falcon Way

Shire Park

Welwyn Garden City

Herts AL7 1TW

United Kingdom

Tel : +44 (0)1707 368004

Fax : +44 (0)1707 363 909

Email : Max.Aibangbee@vegaspace.com

Web : www.vegaspace.com

[fosuzuki]

Hi Max,

since the problem is in the load process, I can only try to help you if you send me the QVD, XLS and QVW files, because I could validate the load. Is it possible?

Regards