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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
AKumar1595005090
Contributor
Contributor

How to split multi array values in multi block.

Hi

i have an issue like if we extract data from trestclient json values are coming like below:

{

      "internalName": "MajorProcessLOPCTier1",

      "investigationId": "[\"91fb0787c9b6aa6a3f2d\",\"b6491d52ebc9f16701db\"]",

      "month": null,

      "year": null,

      "lastUpdatedAt": "08 Jul 2020 11:30:03 AM",

      "locationId": null,

      "referenceLastUpdatedAt": "[\"08 Jul 2020 11:30:03 AM\",\"24 Jun 2020 02:11:16 PM\"]",

      "enterpriseId": null,

      "incidentId": "[\"02a28d47-e9df627e67908312\",\"fa7a84d9-14b8f9ae0482e808\"]",

      "value": "2.0"

    },

so my requirement is to split multi array values in multi block 

expected output :- 

{

       "internalName": "MajorProcessLOPCTier1",

      "investigationId": "[\"91fb0787c9b6aa6a3f2d\"]",

      "month": null,

      "year": null,

      "lastUpdatedAt": "08 Jul 2020 11:30:03 AM",

      "locationId": null,

      "referenceLastUpdatedAt": "[\"08 Jul 2020 11:30:03 AM\"]",

      "enterpriseId": null,

      "incidentId": "[\

"02a28d47-e9df627e67908312

\"]",

      "value": "2.0"

}

  

  {

      "internalName": "MajorProcessLOPCTier1",

      "investigationId": "["b6491d52ebc9f16701db\"]",

      "month": null,

      "year": null,

      "lastUpdatedAt": "08 Jul 2020 11:30:03 AM",

      "locationId": null,

      "referenceLastUpdatedAt": "[\"24 Jun 2020 02:11:16 PM\"]",

      "enterpriseId": null,

      "incidentId": "["

fa7a84d9-14b8f9ae0482e808

\"]",

      "value": "2.0"

    },

Please help

Thanks

Labels (3)
0 Replies