This content has been marked as final. Show 3 replies
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