topic Re: Load script Error in QlikView

Load script Error

techvarun — Mon, 05 Jan 2015 07:07:42 GMT

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

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

Thanks

Varun

Re: Load script Error

Anonymous — Mon, 05 Jan 2015 08:04:10 GMT

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

Re: Load script Error

rajeshvaswani77 — Mon, 05 Jan 2015 08:12:43 GMT

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

Re: Load script Error

djsampat — Mon, 05 Jan 2015 08:14:48 GMT

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

its_anandrjs — Mon, 05 Jan 2015 08:16:22 GMT

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

Re: Load script Error

Anonymous — Mon, 05 Jan 2015 08:20:19 GMT

Hello,

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

Re: Load script Error

Mon, 05 Jan 2015 08:26:05 GMT

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