What's the best way to use a NOT statement in an if statement. I'm trying to accomplish something similar to the below.
| eval x_height=if(isnull(x_height) AND NOT (sourcetype=mysourcetypeHere),"Not Defined",x_height)
This is more clear:
| eval x_height=if((sourcetype=="mysourcetypeHere"), null(), coalesce(x_height, "Not Defined"))
View solution in original post
That worked, thanks!