Splunk Search

How to filter out value based from another another column?

villnooB
Explorer

Hi

Greatly appreciate your help, would like to know if there is any way i could filter out a value based from another column

I need to filter out anything that column 2 gives to column1 
sample:

column1 column2
apple
orange
grapes
grapes
   


expected output
The grape should be removed from column1

column1 column2
apple
orange

grapes

 

will i use where or mvfilter ? 

| where column!=column1

Thank you in advance

Labels (2)
Tags (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

As with much of SPL, there is more than one way to do that.  The method to use depends on how the current output was produced.  Please share the query.

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...