@to4kawa - Thanks for your reply, your solutions works for me. Actually I've just modified the actual JSON and tried to combine two separate JSON, to better explain my query. You've resolved it. Now after seeing your solution I got stuck in count part. Actual JSON contains count field also, below is example. Now as per your solution you are removing count field by "field - count messageList", due to this the original count field is also not displaying, that causes issue to me. Original Valid JSON - [{ "message": { "messageHeader": "MessageHeader", "messageList": [{ "messageName": "messageNameA", "messageValue": "messageValueA", "messageId": "A_Value", "messageStart": "StartDate_Time_Value1", "messageEnd": "EndDate_Time_Value_1", "messageConsumerCount": "Count_MessageA", "count": "MessageCount" }, { "messageName": "messageNameB", "messageValue": "messageValueB", "messageId": "B_Value", "messageStart": "StartDate_Time_Value1", "messageEnd": "EndDate_Time_Value_1", "messageConsumerCount": "Count_MessageB", "count": "MessageCount" }, { "messageName": "messageNameC", "messageValue": "messageValueC", "messageId": "C_Value", "messageStart": "StartDate_Time_Value1", "messageEnd": "EndDate_Time_Value_1", "messageConsumerCount": "Count_MessageC", "count": "MessageCount" }], "messageTotalConsumerCount": "Total Value of Header 1" }, "severity": "info" }, { "message": { "messageHeader": "MessageHeader", "messageList": [{ "messageName": "messageNameA", "messageValue": "messageValueA", "messageId": "A_Value", "messageStart": "StartDate_Time_Value2", "messageEnd": "EndDate_Time_Value_2", "messageConsumerCount": "Count_MessageA", "count": "MessageCount" }, { "messageName": "messageNameC", "messageValue": "messageValueC", "messageId": "C_Value", "messageStart": "StartDate_Time_Value2", "messageEnd": "EndDate_Time_Value_2", "messageConsumerCount": "Count_MessageC", "count": "MessageCount" }, { "messageName": "messageNameB", "messageValue": "messageValueB", "messageId": "B_Value", "messageStart": "StartDate_Time_Value2", "messageEnd": "EndDate_Time_Value_2", "messageConsumerCount": "Count_MessageB", "count": "MessageCount" }, { "messageName": "messageNameD", "messageValue": "messageValueD", "messageId": "D_Value", "messageStart": "StartDate_Time_Value2", "messageEnd": "EndDate_Time_Value_2", "messageConsumerCount": "Count_MessageD", "count": "MessageCount" }], "messageTotalConsumerCount": "Total Value of Header 1" }, "severity": "info" } ] After applying your query, in the output I'm not able to get count field. Thanks!!!
... View more
