Can I use an eval if statement to create a new field based on a value?

[chadman]

I would like to use an if statement to create a new field based on a value. Something like if field1=0 and field2=0, then create new field with value of 1.

[splunkton]

If you want to use case statement this may helps

search | eval newfield=case(field1=field2,1,1=1,0)

[twinspop]

| eval newfield=if(field1=0 and field2=0,1,null)

[gfreitas · Accepted solution]

Hi, you can use that. Follow an old question about it: https://answers.splunk.com/answers/10947/if-statement-with-multiple-tests.html

[chadman]

Perfect! thanks!