I have CSV data and it consists of 3 columns “Name”, “Number” and “Data”.
We need to filter out data based on the “Number” column first, and then check if the “Data” column has values which are there in the “Name” column for that particular value of “Number“ column.
Name Number Data Dragonfruit 4 Chocolate Honey 4 Chocolate 4 Kiwi Icecream 4 Custardapple 4 Error Apple 4
and we need to first remove Data=Null
Final Output should be like this.
Name Number Data Chocolate 4 Kiwi Custardapple 4 Error
May I know how we can achieve this in a search?