Need Urgent help - Script failing with out error

[#1]

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...

[tresesco]

Can you upload the sample app?

Thanks.

[er_mohit]

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

[#4]

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;