Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Parse JSON Array, header and body in different loop

How to parse this json? we need output like this 

"RegistrationId","SurveyId","RegistrationIdCode","DEOCS_UploadStatus","RLSUserCode"
417,2,"KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94","Final","DEOCS_1AB07AA2-95C8-41EF-B109-343384339808"
417,2,"KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94","Final","DEOCS_F6A0327F-0954-4414-9677-44EB4D2305C7"

Input JSON 

{
   "1709a4e1-30dc-4b72-8578-676ccd35c7c9":{
      "columnNames":[
         "RegistrationId",
         "SurveyId",
         "RegistrationIdCode",
         "DEOCS_UploadStatus",
         "RLSUserCode"
      ],
      "data":[
         [
            417,
            2,
            "KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94",
            "Final",
            "DEOCS_1AB07AA2-95C8-41EF-B109-343384339808"
         ],
         [
            417,
            2,
            "KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94",
            "Final",
            "DEOCS_A8605E0F-5E48-4A6C-AAD1-A591FFAA1217"
         ],
         [
            417,
            2,
            "KBR 6/4 #registration-fd0b45fe-4552-4f61-80df-db36bc107d94",
            "Final",
            "DEOCS_F6A0327F-0954-4414-9677-44EB4D2305C7"
         ]
      ],
      "samplingRatio":1.0,
      "totalRowCount":3,
      "rowCount":3,
      "pageSize":100000,
      "offset":0,
      "name":"Daload load validation"
   }
}
Labels (3)
0 Replies