Left Join Freezing up

[azmeerrehan]

I am doing the below left Join

Left Join (Order)

Load

If([DATE A<=DATE B,'On Time',

If(DATE A>DATE B and

DATE A <= DATE C,'Late',

If(DATE A> DATE C,

'vERY LATE'))) as Order_STatus

Resident Order;

IT freezes up on this join  and then gives me  the script error. Any idea what am I doing wrong here

[Anonymous]

in your first if there is a character [ without a closing one

I supoose you Need [DATA A] and all other too

[azmeerrehan]

NO it is there . Its just a typo in the discussion. I am getting the "Execution Of the Script Failed" Error

[manoranjan_d]

i think you have to use field name correctly its case sensitive

TRY1:

field DATE_A it should be defined without space

if its not case sensitive

TRY2:

If(Date(A,'MM-DD-YYYY')<= Date(C,'MM-DD-YYYY'),'On Time',

If(Date(A,'MM-DD-YYYY')> Date(B,'MM-DD-YYYY') and

Date(A,'MM-DD-YYYY')<= Date(C,'MM-DD-YYYY'),'Late',

Date(A,'MM-DD-YYYY')> Date(C,'MM-DD-YYYY'),'VERY LATE')) as Order_STatus

Resident Order;

[manoranjan_d]

pls share the qvw file to us

[stigchel · Accepted solution]

You need to load an unique ID to join on

Left Join (Order)

Load

ID

...

Resident Order;

[azmeerrehan]

If I am doing the LImited load its fine, it eans that I dont have an issue  in the script

[rajivmeher]

Hi Rehan

Please use NUM for date and see if it gets better.

Left Join (Order)

Load

If([NUM(DATE A)<=NUM(DATE B),'On Time',

If(NUM(DATE A)>NUM(DATE B) and

NUM(DATE A) <= NUM(DATE C),'Late',

If(NUM(DATE A)> NUM(DATE C),

'vERY LATE'))) as Order_STatus

Resident Order;

Regards

Rajiv.