Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You need to load an unique ID to join on
Left Join (Order)
Load
ID
...
Resident Order;
in your first if there is a character [ without a closing one
I supoose you Need [DATA A] and all other too
NO it is there . Its just a typo in the discussion. I am getting the "Execution Of the Script Failed" Error
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;
pls share the qvw file to us
You need to load an unique ID to join on
Left Join (Order)
Load
ID
...
Resident Order;
If I am doing the LImited load its fine, it eans that I dont have an issue in the script
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.