Flags in script

[ajsjoshua]

Hi Everyone ,

I want to set flags for Order1,order2,order3

Order1

if  ActualDispQty and ActualDispVol is  NULL then

sum(VolBeingBilled) is Order1

:

Order2:

if  ActualDispQty has values

RecvdQty=NuLL

then sum(ActualDispQty )

Order3:

if  ActualDispQty and VolBeingBilled has  values then

sum(ActualDispQty ) -sum(VolBeingBilled )  is Order3

PFA

[arasantorule]

Hi,

If I understnad your requirement correctly.

A new flag field called Order is required with the three flag values (Order1, Order2, Order3) in the table for the above explained conditions.

Also can you provide us a sample excel data.

Thanks.

[ajsjoshua]

Hi arasantorule

You  are correct but i have only QVD.

Regards,

Joshua.

[arasantorule]

Can you just share 10 rows if possible.

Thanks.

[ajsjoshua]

Hi,

PFA

[ajsjoshua]

Hi,

cusReqETA is date.

[arasantorule]

Hi,

I couldnt attach the app hence script.

LOAD date(CustReqETA) as CustReqETA,

     ActualDispQty,

     ActualDispVol,

     RecvdQty,

     VolBeingBilled,

     if((ActualDispQty =0 OR LEN(ActualDispQty)=0)  and (ActualDispVol=0 OR LEN(ActualDispVol)=0),'Order1',

     if(ActualDispQty>0 and (RecvdQty=0 OR RecvdQty=Null()),'Order2',

     if(ActualDispQty>0 and VolBeingBilled>0,'Order3'))) as Order

FROM

(biff, embedded labels, table is Sheet1$);

Please let me know if you have any queries.

Thanks.