3 Replies Latest reply on Feb 14, 2018 11:43 AM by inuser470040

    ICRT output array within array

    Active Member

      Good Afternoon team,

       

      I have yet another question to ask

       

      I have 2 tables :

      1.Student Detail(First_name, last_name, DOB, Grade)

      2.Student Mark List (first_name, last_name,Grade, Sub1_title, sub1_score, Sub2_title, sub2_score, Sub3_title, sub3_score, Sub4_title, sub4_score)

       

      I am trying to achieve the below output using ICRT. But I am unable to.

       

      output:

      {"Student Data":

      [{"first name":"Ragini", "last name":"Neeru", "Grade":"5",

           "Score":{"Subject1":{"title":"English","score":"80"},

                         "Subject2":{"title":"Math","score":"90"},

                         "Subject3":{"title":"Latin","score":"95"}

                        }

      },

      {"first name":"Raani", "last name":"Neeru", "Grade":"6",

           "Score":{"Subject1"{"title":"Math","score":"90"},

                         "Subject2":{"title":"Social","score":"95"}

                        }

      }

      ]

      }

       

      Please let me know if you have any ideas/suggestion.. Appreciate your help greatly.

       

      Thanks,

      Ragini