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.