I have categories.csv that contains list of sub-categories in each category
Category,Sub_category
Biology,Botany
Biology,Zoology
Physical_Science,Physics
Physical_Science,Chemistry
In another file I have the results for all sub-categories
Subject,Result
Botany,Pass
Zoology,Fail
Physics,Being_revaluted
Chemistry,Pass
I need to compute the overall result per category like
Biology,Physical_Science
Fail,Being_revaluted
Please help me achieve the above mentioned objective
I am able to extract the list of sub-categories in any particular category, say Biology, using the below code
source="/tmp/categories.csv" host="pc1" index="my_index" Category="Biology" | eval Sub_cat=Sub_category | search Category=Biology | table Category Sub_cat
The above code gives
Category,Sub_cat
Biology,Botony
Biology,Zoology
... View more