Load script Error

[techvarun]

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

[Anonymous]

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]

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]

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]",

...

[its_anandrjs]

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

[Anonymous]

Hello,

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

[#7]

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