IF function with multiple values

[#1]

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

[MayilVahanan]

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)

[prashantbaste · Accepted solution]

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

[#4]

Tha nks Mayil and Prasant