https://community.splunk.com/t5/Splunk-Search/where-command-for-innotnull/m-p/455028#M171237 <P>Hi</P> <P>Give a try</P> <PRE><CODE>yourquery...|search "Stage 1"=* </CODE></PRE> Tue, 14 May 2019 16:19:22 GMT vnravikumar 2019-05-14T16:19:22Z https://community.splunk.com/t5/Splunk-Search/where-command-for-innotnull/m-p/455027#M171236 <P>Hi, <BR /> I'm new to splunk and<BR /> I'm trying to exclude null values for one of the columns in my datasheet. <BR /> That column as two different values and few rows are blank.<BR /> Tried where command but not getting the result.<BR /> values of the columns "Stage 1" are "Stage1" &amp; "Stage2" &amp; remaining blank rows</P> <P>| where isnotnull("Stage 1")...... ---- didn't work<BR /> | where "Stage 1" = "Stage1" OR "Stage2" ..... -------didn't work</P> <P>Please help me with this.</P> Tue, 14 May 2019 15:37:43 GMT https://community.splunk.com/t5/Splunk-Search/where-command-for-innotnull/m-p/455027#M171236 AditiGhule 2019-05-14T15:37:43Z https://community.splunk.com/t5/Splunk-Search/where-command-for-innotnull/m-p/455028#M171237 <P>Hi</P> <P>Give a try</P> <PRE><CODE>yourquery...|search "Stage 1"=* </CODE></PRE> Tue, 14 May 2019 16:19:22 GMT https://community.splunk.com/t5/Splunk-Search/where-command-for-innotnull/m-p/455028#M171237 vnravikumar 2019-05-14T16:19:22Z