jsonq icon indicating copy to clipboard operation
jsonq copied to clipboard

Making nested aggregations to compare student result into materials through multiple months

Open M-Samy opened this issue 3 years ago • 0 comments

@nahid ################ Json Data 1 ###################### { "student_results": [ { "month": "month1", "results": [ { "material_code": "Math", "result": "20", }, { "material_code": "English", "result": "50", }, ] } ] }

################ Json Data 2 ###################### { "student_results": [ { "month": "month2", "results": [ { "material_code": "Math", "result": "30", }, { "material_code": "English", "result": "48", }, ] } ] }

################ Expected result ######################

{ "student_results": [ { "month": "month2", "results": [ { "material_code": "Math", "result": "30", }, { "material_code": "English", "result": "50", }, ] } ] }

M-Samy avatar May 28 '21 17:05 M-Samy