|eval SNOW_Description=case(EMGC_ADMINSERVER_Status!="k1","Java Process EMGC_ADMINSERVER data not available in splunk on host, EMGC_ORACLE_Status!="k2","Java Process EMGC_ORACLE data not available in splunk on host)
Here I am trying to use multiple fields inside case statement. I am not getting correct output. How can this be achieved?
|eval SNOW_Description=case(EMGC_ADMINSERVER_Status!="k1","Java Process EMGC_ADMINSERVER data not available in splunk on host, EMGC_ORACLE_Status!="k2","Java Process EMGC_ORACLE data not available in splunk on host)
In the above query, I am getting the output if the first condition EMGC_ADMINSERVER_Status!="k1" is met.
I am expecting to get the output when both conditions EMGC_ADMINSERVER_Status!="k1 and EMGC_ORACLE_Status!="k2" are met.
Case is evaluated from the left until a condition is met.
So if the first condition is met, subsequent ones are not evaluated. You might want to rethink your conditions/evaluation order.
What output are you getting and what output do you expect? The title of the post says "multi valued field", but the body says "multiple fields". That's two different things so which is the case? The latter is commonplace and should work easily, whereas the former requires one or more mv* functions.
That looks like it should work once the quotation marks are matched up.