topic please help - Error : duplicate keys when loading input field in QlikView

please help - Error : duplicate keys when loading input field

Thu, 27 Oct 2011 09:26:02 GMT

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)

;

please help - Error : duplicate keys when loading input field

fosuzuki — Thu, 27 Oct 2011 09:50:36 GMT

Have you tried to use LOAD DISTINCT?

please help - Error : duplicate keys when loading input field

Thu, 27 Oct 2011 10:00:42 GMT

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.

please help - Error : duplicate keys when loading input field

Thu, 27 Oct 2011 10:35:10 GMT

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.

please help - Error : duplicate keys when loading input field

fosuzuki — Thu, 27 Oct 2011 13:16:39 GMT

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

Re: please help - Error : duplicate keys when loading input field

Thu, 27 Oct 2011 13:40:47 GMT

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

Re: please help - Error : duplicate keys when loading input field

fosuzuki — Fri, 11 Nov 2011 11:26:08 GMT

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