How to split multi array values in multi block.

AKumar1595005090 — Sun, 19 Jul 2020 15:20:47 GMT

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

topic How to split multi array values in multi block. in Talend Studio