Script Error

[#1]

Hi guys plz help me on this,I am new to this..this error is coming when I am clicking the reload button in the script.

.I am taking the data from a BI cube.PFA the script also.

Thanks in advance for the help

Field not found - <_0DIVISION>

FINAL:

LOAD _0DIVISION,

     _0MATERIAL,

     _0MATL_GROUP,

     _0MAT_DOC,

     _0PLANT,

     _0SUPPLIER,

     _0FISCVARNT,

     _0CURRENCY,

     _0UNIT,

     Measures_0PRICE_UNIT,

     Measures_Z_AC_SAVE,

     Measures_Z_FR_PR,

     Measures_Z_FR_QTY,

     Measures_Z_FR_SPND

FROM

[http://localhost:8085/?name=final]

(txt, utf8, embedded labels, delimiter is ',')

[Anonymous]

Try:

LOAD _0MATERIAL,
     _0DIVISION,

     _0MATL_GROUP,

     _0MAT_DOC,

     _0PLANT,

     _0SUPPLIER,

     _0FISCVARNT,

     _0CURRENCY,

     _0UNIT,

     Measures_0PRICE_UNIT,

     Measures_Z_AC_SAVE,

     Measures_Z_FR_PR,

     Measures_Z_FR_QTY,

     Measures_Z_FR_SPND

FROM

[http://localhost:8085/?name=final]

(txt, utf8, embedded labels, delimiter is ',')

You probebly now get an error on _0MATERIAL , right?

If that is the case your problem is not the field names but it is in the FROM-part (because it justs gives an error on the first field it is trying to load)

[rwunderlich]

Did you generate this script statement using the wizard? Usually when loading from http there is a "table is n" parm that specifies the html table number.

-Rob

[#4]

Hi Rob

I did not understand what is 'table is n' parm..plz can u xplain

and I think that I am getting this error bocz of some local host issue..Do we need to do some extra configurations for Qlikview?

[#5]

Hi Rob

I did not understand what is 'table is n' parm..plz can u xplain

and I think that I am getting this error bocz of some local host issue..Do we need to do some extra configurations for Qlikview?

[Anonymous]

More improtant is the first part of Rob's question ; "Did you generate this script statement using the wizard? "

Normaly using the wizard will get you the right script.

[#7]

No I guess...Can you plz tell me how do I generate script using Wizard..I am using xtract QV to generate the script..then I paste that in Qlikview..

[Anonymous]

When you go to the load script (CTRL+e)

Choose below the button "Internet files" This will open the wizard.

[#9]

Yes ok I have opened the Wizard...then what do I put in that ? I need to take data from SAP BI

[#10]

Yes ok I have opened the Wizard...then what do I put in that ? I need to take data from SAP BI

[Anonymous]

I dont know SAP BI but if I see your previous script it looks like you are trying to connect to a url, right?

So see what happens if you fill in:

http://localhost:8085/?name=final

in the Internet file field.....