Below is my requirement.
I have 2 fields in my system (1. Category & 2. Questions)
Here is my requirement goes. and below is my data.
My requirement. I need to Manually add one more new field called Sub category by writing elastic search query which is not there in the system. with the below criteria.
- If my question is "I need to get parcel as soon as possible" AND Category is "Expediate" Then it should be "Express" as subcategory
- If my question is "I need parcel after 2 days" AND Category is "Medium" Then it should be "MIDLEVEL" as subcategory
- If my question is "I need today itself " AND Category is "Super fast " Then it should be "HIGHER" as subcategory
Below should be my output
Need Questions field aggregation
Need New field as subcategory aggregation
Expected result : aggregate the data such that there's a new column which depends on the original