6 Replies Latest reply: Jan 5, 2015 3:26 AM by Venkat Reddy Palla RSS

    Load script Error

    Varun Prakash Paulraj

      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

        • Re: Load script Error
          Vignesh Vs

          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
              Dhruv Sampat

              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
              Rajesh Vaswani

              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
                Anand Chouhan

                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
                  Ravichandra Nadiminti

                  Hello,

                   

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

                  • Re: Load script Error
                    Venkat Reddy Palla

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