HiGreatly appreciate your help, would like to know if there is any way i could filter out a value based from another columnI need to filter out anything that column 2 gives to column1 sample:
expected outputThe grape should be removed from column1
will i use where or mvfilter ? | where column!=column1Thank 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.