Hi All, I have this compressed (reduced version of large structure) which is a combination of basic text and JSON: 2024-07-10 07:27:28 +02:00 LiveEvent: {"data":{"time_span_seconds":300,
"active":17519,
"total":17519,
"unique":4208,
"total_prepared":16684,
"unique_prepared":3703,
"created":594,
"updated":0,
"deleted":0,"ports":[
{"stock_id":49,
"goods_in":0,
"picks":2,
"inspection_or_adhoc":0,
"waste_time":1,
"wait_bin":214,
"wait_user":66,
"stock_open_seconds":281,
"stock_closed_seconds":19,
"bins_above":0,
"completed":[43757746,43756193],
"content_codes":[],
"category_codes":[{"category_code":4,"count":2}]},
{"stock_id":46,
"goods_in":0,
"picks":1,
"inspection_or_adhoc":0,
"waste_time":0,
"wait_bin":2,
"wait_user":298,
"stock_open_seconds":300,
"stock_closed_seconds":0,
"bins_above":0,
"completed":[43769715],
"content_codes":[],
"category_codes":[{"category_code":4,"count":1}]},
{"stock_id":1,
"goods_in":0,
"picks":3,
"inspection_or_adhoc":0,
"waste_time":0,
"wait_bin":191,
"wait_user":40,
"stock_open_seconds":231,
"stock_closed_seconds":69,
"bins_above":0,
"completed":[43823628,43823659,43823660],
"content_codes":[],
"category_codes":[{"category_code":1,"count":3}]}
]},
"uuid":"8711336c-ddcd-432f-b388-8b3940ce151a",
"session_id":"d14fbee3-0a7a-4026-9fbf-d90eb62d0e73",
"session_sequence_number":5113,
"version":"2.0.0",
"installation_id":"a031v00001Bex7fAAB",
"local_installation_timestamp":"2024-07-10T07:35:00.0000000+02:00",
"date":"2024-07-10",
"app_server_timestamp":"2024-07-10T07:27:28.8839856+02:00",
"event_type":"STOCK_AND_PILE"} I eventually need each “stock_id” ending up as an individual event, and keep the common information along with it like: timestamp, uuid, session_id, session_sequence_number and event_type. Can someone guide me how to use props and transforms to achieve this? PS. I have read through several great posts on how to split JSON arrays into events, but none about how to keep common fields in each of them. Many thanks in advance. Best Regards, Bjarne
... View more