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
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.