Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Error

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 ',')

19 Replies
juleshartley
Specialist
Specialist

It looks like the error says - it can't find that field. Are you sure it's named correctly? Being the first field it may mean that it can't read the data source... are you sure it is connecting? Can you try and return just one of the other fields?

Not applicable
Author

Yes I have checked it with the other fields also..Its giving the same error again.And also I checked for the connection also.

er_mohit
Master II
Master II

IfYou must know the error because of this field

then try to enclose that field in square bracket i think it because of space

[_0DIVISION]

hope it helps

juleshartley
Specialist
Specialist

I would try a 'load * from' first. If this fails then it is your data connection - so you need to rebuild that.

perhaps specify the server instead of using localhost?

Not applicable
Author

Yes I have checked it with the other fields also..Its giving the same error again.And also I checked for the connection also.

Not applicable
Author

I think , you write your field inside this [  ]  bracket.

Not applicable
Author

Guys I appreciate ur answers and efforts..But none of the suggestions are working

Not applicable
Author

Guys I appreciate ur answers and efforts..But none of the suggestions are working

Not applicable
Author

Guys I appreciate ur answers and efforts..But none of the suggestions are working