Many thanks for the help. I want to expand the requirement as follows: For an "id" there could be upto 12 max possible different events with response.action.type="UserCreated" or response.action.type="TxCreated" or response.action.type="TxUpdated" and 9 other types. The goal is to group by "id" where only 2 action types have occured namely: response.action.type="UserCreated" (Event1) and response.action.type="TxCreated" (Event 2) Event Type 1 data= { "response": { "action": { "type": "UserCreated", } "resources":[ { "type": "loginUser", "id": "1234" } ] } } Event Type 2 data= { "response": { "action": { "type": "TxCreated", } "actors": { "type": "loginUser", "id": "1234" } } } Event Type 3 data= { "response": { "action": { "type": "TxUpdated", } "actors": { "type": "loginUser", "id": "1234" } } }
... View more