Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

techvarun
Valued Contributor II

Load script Error

Hello Qlixperts

                         Today I am facing a strange error.

   I am loading a qvd file

when i load using the below script

LOAD *

FROM

[test.qvd]

(qvd);

I am able to load the data but when i try loading the same with

LOAD DPG,

     [Planning Product],

     S6EF,

     A1CF2,

     S6DFFS,

     S6OF,

     CALWEEK,

     S6RLSWK,

     [wk/yr],

     [Release Week],

     Market,

     Region,

     State,

     SubBrand,

     [Enr Fcst 0],

     [Enr Fcst 1],

     [Enr Fcst 2],

     [Enr Fcst 3],

     [Enr Fcst 4],

     [Enr Fcst 5],

     [Enr Fcst 6],

     [Enr Fcst 7],

     [Enr Fcst 8],

     [Enr Fcst 9],

     [Enr Fcst 10],

     [Enr Fcst 11],

     [Enr Fcst 12],

     [Enr Fcst 13],

     [Wholesaler Forecast 0],

     [Wholesaler Forecast 1],

     [Wholesaler Forecast 2],

     [Wholesaler Forecast 3],

     [Wholesaler Forecast 4],

     [Wholesaler Forecast 5],

     [Wholesaler Forecast 6],

     [Wholesaler Forecast 7],

     [Wholesaler Forecast 8],

     [Wholesaler Forecast 9],

     [Wholesaler Forecast 10],

     [Wholesaler Forecast 11],

     [Wholesaler Forecast 12],

     [Wholesaler Forecast 13],

     [Comm Fcst 0],

     [Comm Fcst 1],

     [Comm Fcst 2],

     [Comm Fcst 3],

     [Comm Fcst 4],

     [Comm Fcst 5],

     [Comm Fcst 6],

     [Comm Fcst 7],

     [Comm Fcst 8],

     [Comm Fcst 9],

     [Comm Fcst 10],

     [Comm Fcst 11],

     [Comm Fcst 12],

     [Comm Fcst 13],

     [Operational Forecast 0],

     [Operational Forecast 1],

     [Operational Forecast 2],

     [Operational Forecast 3],

     [Operational Forecast 4],

     [Operational Forecast 5],

     [Operational Forecast 6],

     [Operational Forecast 7],

     [Operational Forecast 8],

     [Operational Forecast 9],

     [Operational Forecast 10],

     [Operational Forecast 11],

     [Operational Forecast 12],

     [Operational Forecast 13],

     [Wk/Yr],

     Sales,

     WSLR#,

     City,

     [State Init.]

FROM

[test.qvd]

(qvd

I am getting an error as below

Load script error.png

Qvd attached Please suggest some ideas and possible ways to laod the QVD using script the script

Thanks

Varun

6 Replies
vigneshvs
Contributor II

Re: Load script Error

Hi,

Whenever your using the [] in the script which holds a number as well then you have to define those fields in "" like mentioned below.

"[Enr Fcst 0]"

Hope this solves your problem.

Thanks,

Vignesh

rajeshvaswani77
Valued Contributor III

Re: Load script Error

Hi Varun,

The field [Enr Fcst 0] seems to be missing.


Go to edit script and select table files and then the QVD, all the fields that are there in the QVD will get picked up.

regards,

Rajesh Vaswani

djsampat
Contributor II

Re: Load script Error

I concur. Use the double quotes to get the data to load.

All Forcast columns should be modified as below:-

     "[Enr Fcst 0]",

     "[Enr Fcst 1]",

     "[Enr Fcst 2]",

     "[Enr Fcst 3]",

     "[Enr Fcst 4]",

     "[Enr Fcst 5]",

     "[Enr Fcst 6]",

     "[Enr Fcst 7]",

     "[Enr Fcst 8]",

     "[Enr Fcst 9]",

     "[Enr Fcst 10]",

     "[Enr Fcst 11]",

     "[Enr Fcst 12]",

     "[Enr Fcst 13]",

...

Re: Load script Error

Hi,

When this Qvd created the field name should be   Enr_Fcst_0 like this way need to be given to field name in the QVD creation because field contains numbers which is integer. So in this way right now you can load fields.

Better you make changes in the QVD maker.

you can load right now as

Load

"[Enr Fcst 0]"

..

..

From Source;

Regards

Anand

ravic906
Contributor III

Re: Load script Error

Hello,

use "[Enr Frct 0] " and so on for those fields. It will resolve ur prob.

Not applicable

Re: Load script Error

Directory;

LOAD DPG,

     [Planning Product],

     S6EF,

     A1CF2,

     S6DFFS,

     S6OF,

     CALWEEK,

     S6RLSWK,

     [wk/yr],

     [Release Week],

     Market,

     Region,

     State,

     SubBrand,

     "[Enr Fcst 0]",

      "[Enr Fcst 1]",

      "[Enr Fcst 2]",

      "[Enr Fcst 3]",

      "[Enr Fcst 4]",

      "[Enr Fcst 5]",

      "[Enr Fcst 6]",

      "[Enr Fcst 7]",

      "[Enr Fcst 8]",

      "[Enr Fcst 9]",

      "[Enr Fcst 10]",

      "[Enr Fcst 11]",

      "[Enr Fcst 12]",

      "[Enr Fcst 13]",

      "[Wholesaler Forecast 0]",

      "[Wholesaler Forecast 1]",

      "[Wholesaler Forecast 2]",

      "[Wholesaler Forecast 3]",

      "[Wholesaler Forecast 4]",

      "[Wholesaler Forecast 5]",

      "[Wholesaler Forecast 6]",

      "[Wholesaler Forecast 7]",

      "[Wholesaler Forecast 8]",

      "[Wholesaler Forecast 9]",

      "[Wholesaler Forecast 10]",

      "[Wholesaler Forecast 11]",

      "[Wholesaler Forecast 12]",

      "[Wholesaler Forecast 13]",

      "[Comm Fcst 0]",

      "[Comm Fcst 1]",

      "[Comm Fcst 2]",

      "[Comm Fcst 3]",

      "[Comm Fcst 4]",

      "[Comm Fcst 5]",

      "[Comm Fcst 6]",

      "[Comm Fcst 7]",

      "[Comm Fcst 8]",

      "[Comm Fcst 9]",

      "[Comm Fcst 10]",

      "[Comm Fcst 11]",

      "[Comm Fcst 12]",

      "[Comm Fcst 13]",

      "[Operational Forecast 0]",

      "[Operational Forecast 1]",

      "[Operational Forecast 2]",

      "[Operational Forecast 3]",

      "[Operational Forecast 4]",

      "[Operational Forecast 5]",

      "[Operational Forecast 6]",

      "[Operational Forecast 7]",

      "[Operational Forecast 8]",

      "[Operational Forecast 9]",

      "[Operational Forecast 10]",

      "[Operational Forecast 11]",

      "[Operational Forecast 12]",

      "[Operational Forecast 13]",

      [Wk/Yr],

     Sales,

     WSLR#,

     City,

      [State Init.]

FROM

[..\Downloads\test.qvd]

(qvd);

Community Browser