Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Can you just share 10 rows if possible.
Thanks.
Hi,
PFA
Hi,
cusReqETA is date.
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.