Splunk Search

where command for innotnull

AditiGhule
New Member

Hi,
I'm new to splunk and
I'm trying to exclude null values for one of the columns in my datasheet.
That column as two different values and few rows are blank.
Tried where command but not getting the result.
values of the columns "Stage 1" are "Stage1" & "Stage2" & remaining blank rows

| where isnotnull("Stage 1")...... ---- didn't work
| where "Stage 1" = "Stage1" OR "Stage2" ..... -------didn't work

Please help me with this.

Tags (1)
0 Karma

vnravikumar
Champion

Hi

Give a try

yourquery...|search "Stage 1"=*
0 Karma
Get Updates on the Splunk Community!

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...

Index This | What goes up and never comes down?

January 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Splunkers, Pack Your Bags: Why Cisco Live EMEA is Your Next Big Destination

The Power of Two: Splunk + Cisco at "Ludicrous Scale"   You know Splunk. You know Cisco. But have you seen ...