Hello All,
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.
Ex.
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?
Thanks
Gajanan Hiroji
Hello! Just try some thing like this
<your base search> |were Data!=" "|table Name Number Data
Thanks
Hello Thanks for the reply but how do you match Data column values with Name Column values with respect to particular number?
Here you go:
<your base search> |were Data!=" "|stats values(Name) as Name, values(Data) as Data by Number|table Number Data Name