Is there a way to add a field to an event from a different event assuming they have a common key using a simple search (without using pipe)? The reason being the resulting event will need to be tagged via event type (which doesn't allow complex search) so it can be included as part of a data model.
Event 1 - field A (common key): ABC, field B: Sunny
Event 2 - field A (common key): ABC, field C: Morning
Resulting Event 1: field A: ABC, field B: Sunny, field C: Morning
The final event will then be tagged so it can be included in the data model.
Using "transaction" does provide the field I need as it groups the related events, but I need the field from the second event to be there on the first event permanently so when we do search it would appear as part of the result - so I can't really use "transaction" in this case.
Ideally the two events should have been ingested as a single event so we won't have this problem, but that's not the case.