Combining (grouping) two records as one in Kibana Discover

[usman1 (Muhammad Usman)]

Hi,

I want to group (aggregate) records on the basis of a specific ID. At the moment, my data has an event START and END record identified by the IDs. START and END record have different fields in them which I want to combine in one row.
The current mapping is similar to the attached image:

Here, Batch_ID is the field which I want to use for combining. I want to combine the fields from both START and END records in such a way that one row has important fields from both records.

Thanks.

[Felix_Roessel]

This type of aggregation can not be done in Discover. However you can use the data table vis to achieve that.

Best option is to join those events during index or by using transforms.

[usman1 (Muhammad Usman)]

Thank you for the response @Felix_Roessel.

Joining events while indexing might not be possible as the duration of time between both these events can be in hours. Regarding the use of table vis or transforms, any useful link will be highly appreciated. Though, I will explore these options on my own as well.