Splunk Dev

don't show rows with specific column values

zacksoft
Contributor

| base search
table amount, currency , received, time

The value of 'received' field is either 0 or 1.

I want my table to show rows where the value of column 'received' is '1'.

Tags (1)
0 Karma
1 Solution

deepashri_123
Motivator

Hey zacksoft,

Try this:
| base search
table amount, currency , received, time | search received = "1"

Let me know if this helps!!

View solution in original post

0 Karma

deepashri_123
Motivator

Hey zacksoft,

Try this:
| base search
table amount, currency , received, time | search received = "1"

Let me know if this helps!!

0 Karma

zacksoft
Contributor

This works. Thank u.
One more thing. I also want to add the condition there,
show me only the rows where "received"="1" and "currency" not equal to "dollar" or "sterling" ??

0 Karma

deepashri_123
Motivator

| base search
table amount, currency , received, time | search received = "1" AND currency!="dollar" AND currency!="sterling"

Please accept the answer if it worked!!
Thanks!!

0 Karma

zacksoft
Contributor

I think this won't work .It is checking here if all three conditions are true.
What I am looking for is received = "1" condition must be true AND Currency not equal to dollar OR Sterling OR Mac.

Hope I didn't confuse

0 Karma

deepashri_123
Motivator

try this
| base search
table amount, currency , received, time | search received = "1" AND (currency!="dollar" OR currency!="sterling" OR currency!="mac")

0 Karma

493669
Super Champion

Hi @zacksoft,
try this:

|base search|where received="1"|table amount, currency , received, time
0 Karma

493669
Super Champion

for the additional condition try this:

|base search|where received="1" AND currency!="dollar" AND currency!="sterling" |table amount, currency , received, time
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...