topic Garbage after statement Script Error in QlikView

Garbage after statement Script Error

kakani87 — Wed, 10 Jan 2018 09:41:13 GMT

Dear All,

I'm facing a script error like garbage after statement in the following script, can any one identify where I'm going wrong.

let v_val=mid(v_val,Index(v_val,'>')+1,Len(v_val)-Index(v_val,'>'));

let v_firstloop=Index(v_val,']');

let v_count=0;

do while v_firstloop<>0

if Index(v_val,']')<>0 and Index(v_val,'//')=0 then

let v_fieldname=replace(text(mid(v_val,Index(v_val,']')+1,(Index(v_val,'(')-1) - (Index(v_val,']')+1))),'&','');

//EXIT Script; st

<<<<<<<<<< TILL THIS POINT NO ERROR >>>>>>>>>>>>

if v_fieldname='Supp:' then

let v_val=mid(v_val,Index(v_val,':')+1,Len(v_val)-(Index(v_val,':')-2));

let v_old=text(mid(v_val,Index(v_val,':'),(Index(v_val,')')-1) - (Index(v_val,':'))));

let v_val=mid(v_val,Index(v_val,')')+1,Len(v_val)-(Index(v_val,')')-2));

let v_val=mid(v_val,Index(v_val,':')-1,Len(v_val)-(Index(v_val,':')-2));

let v_new=text(mid(v_val,Index(v_val,':')+1,(Index(v_val,')')-1) - (Index(v_val,':'))));

Re: Garbage after statement Script Error

Anil_Babu_Samineni — Wed, 10 Jan 2018 09:46:33 GMT

After If Then condition you haven't used Else condition anymore hence it throw error

if v_fieldname='Supp:' then

let v_val=mid(v_val,Index(v_val,':')+1,Len(v_val)-(Index(v_val,':')-2));

let v_old=text(mid(v_val,Index(v_val,':'),(Index(v_val,')')-1) - (Index(v_val,':'))));

Else

let v_val=mid(v_val,Index(v_val,')')+1,Len(v_val)-(Index(v_val,')')-2));

let v_val=mid(v_val,Index(v_val,':')-1,Len(v_val)-(Index(v_val,':')-2));

let v_new=text(mid(v_val,Index(v_val,':')+1,(Index(v_val,')')-1) - (Index(v_val,':'))));

Re: Garbage after statement Script Error

kakani87 — Wed, 10 Jan 2018 10:41:15 GMT

Check this Anil Else is considered. Till the exit script it is executing after that throwing error

let v_val=mid(v_val,Index(v_val,'>')+1,Len(v_val)-Index(v_val,'>'));

let v_firstloop=Index(v_val,']');

let v_count=0;

do while v_firstloop<>0

if Index(v_val,']')<>0 and Index(v_val,'//')=0 then

let v_fieldname=replace(text(mid(v_val,Index(v_val,']')+1,(Index(v_val,'(')-1) - (Index(v_val,']')+1))),'&','');

//EXIT Script;

if v_fieldname='Supp:' then

let v_val=mid(v_val,Index(v_val,':')+1,Len(v_val)-(Index(v_val,':')-2));

let v_old=text(mid(v_val,Index(v_val,':'),(Index(v_val,')')-1) - (Index(v_val,':'))));

let v_val=mid(v_val,Index(v_val,')')+1,Len(v_val)-(Index(v_val,')')-2));

let v_val=mid(v_val,Index(v_val,':')-1,Len(v_val)-(Index(v_val,':')-2));

let v_new=text(mid(v_val,Index(v_val,':')+1,(Index(v_val,')')-1) - (Index(v_val,':'))));

let v_val=mid(v_val,Index(v_val,')')+1,Len(v_val)-(Index(v_val,')')-2));

else

let v_val=mid(v_val,Index(v_val,':')-1,Len(v_val)-(Index(v_val,':')-2));

let v_old=text(mid(v_val,Index(v_val,':')+1,(Index(v_val,')')-1) - (Index(v_val,':'))));

let v_val=mid(v_val,Index(v_val,')')+1,Len(v_val)-(Index(v_val,')')-2));

let v_val=mid(v_val,Index(v_val,':')-1,Len(v_val)-(Index(v_val,':')-2));

let v_new=text(mid(v_val,Index(v_val,':')+1,(Index(v_val,')')-1) - (Index(v_val,':'))));

let v_val=mid(v_val,Index(v_val,')')+1,Len(v_val)-(Index(v_val,')')-2));

end if

let v_old=Replace(v_old,']','');

let v_old=Replace(v_old,'[','');

let v_new=Replace(v_new,']','');

let v_new=Replace(v_new,'[','');

let v_fieldname=text(replace(Replace(v_fieldname,'[',''),']',''));

if $(v_tran_header_flag)=0 then

TRAN_HEADER:

load * inline

[

Srno,FieldName,Old,New

$(v_srno),'$(v_fieldname)','$(v_old)','$(v_new)'

];

end if

Re: Garbage after statement Script Error

stigchel — Wed, 10 Jan 2018 11:31:24 GMT

From your screenshot I can see there are [ ] in your values in the inline load

==> PRADEEP [1]

Load values where you have these characters as e.g.

something [1]]

right bracket escaped without the single quotes

Re: Garbage after statement Script Error

Anil_Babu_Samineni — Wed, 10 Jan 2018 11:32:21 GMT

Do While should end up with LOOP;