How to filter out value based from another another column?

villnooB — Tue, 14 Feb 2023 19:36:47 GMT

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

Re: filter out value based from another another column

richgalloway — Tue, 14 Feb 2023 13:43:48 GMT

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.

topic How to filter out value based from another another column? in Splunk Search

How to filter out value based from another another column?

Re: filter out value based from another another column