topic Re: Need Urgent help - Script failing with out error in QlikView

Need Urgent help - Script failing with out error

Wed, 15 May 2013 04:19:47 GMT

Hi All,

while I was loading the data suing the preceeding load statment which look something like this..

119 fields found: x,y,z, orderintake_inv_date,

there is one more field after orderintake_inv_date.there is no error i see in the script.Not sure what the issue is actually.. the load statement looks like this

tmpClosedOpenOrders:

LOAD

if(Order_Status='Closed',[org Invoiced Date]) as orderintake_inv_date,

if(Order_Status='Closed',[org Invoiced Date],if(Order_Status='Open' or Order_Status='Cancelled' or Order_Status='NegOrdIntake',Orderentereddate)) as %keySales_ID_date

resident tmpClosedOpenOrders1;

drop table tmpClosedOpenOrders1;

Can some help me in this plz...

Thanks in advance...

Re: Need Urgent help - Script failing with out error

tresB — Wed, 15 May 2013 04:48:53 GMT

Can you upload the sample app?

Thanks.

Re: Need Urgent help - Script failing with out error

er_mohit — Wed, 15 May 2013 05:01:00 GMT

you write the tablename tmpClosedOpenOrders1 which one you drop

and this table name you write tmpClosedOpenOrders where your all fields have

in qlikview it seems like same table name and concate it

try to use tmpClosedOpenOrders_1

hope it helps you

Re: Need Urgent help - Script failing with out error

Wed, 15 May 2013 05:21:12 GMT

tmpClosedOpenOrders:

LOAD

if(Order_Status='Closed',[org Invoiced Date]) as orderintake_inv_date,

if(Order_Status='Closed',[org Invoiced Date],if(Order_Status='Open' or Order_Status='Cancelled' or Order_Status='NegOrdIntake',Orderentereddate)) as %keySales_ID_date

resident tmpClosedOpenOrders1;

drop table tmpClosedOpenOrders1;

here if you use resident load, and then drop the table so field must be not found, because you drop the field.because you load the same field as resident load and then drop the same field. so this field not found,so either you change the field name in resident load or load table as presedent load.

so you write only

LOAD

if(Order_Status='Closed',[org Invoiced Date]) as orderintake_inv_date,

if(Order_Status='Closed',[org Invoiced Date],if(Order_Status='Open' or Order_Status='Cancelled' or Order_Status='NegOrdIntake',Orderentereddate)) as %keySales_ID_date

resident tmpClosedOpenOrders1;