Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can we use the below script while loading:
sum(if(match(A,'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]') and B='Processed', 1,0) ) as C
If not, please suggest an alternative.
My requirement is to get the count of total records in a field called C where
A=00:30 hrs , 01:00 hrs , 01:30 hrs
and
B=Processed
TIA
Regards,
Rishikesh
Hi Kumar Rishikesh
You can use
sum(if(match(A,'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]') and B='Processed', 1,0) ) as C
but then you need to use groupby with respect too some field to get desired result.
Hope this will be helpful for you.
--
Regards,
Prashant P Baste
Hi
Try like this'
In Script:
if(match(A,'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]') and B='Processed', 1,0) as C
Then in front end, you can use Sum(C)
Hi Kumar Rishikesh
You can use
sum(if(match(A,'[00:30 hrs]','[01:00 hrs]','[01:30 hrs]') and B='Processed', 1,0) ) as C
but then you need to use groupby with respect too some field to get desired result.
Hope this will be helpful for you.
--
Regards,
Prashant P Baste
Tha nks Mayil and Prasant