I have results in the following form and would like to filter for only those results matching a session_id=x and an object_id=y, or those first encountered in the results. Any ideas?
Session_Id | Object_Id
x | y
x | y
x | z
x | z
x | z
a | b
a | b
a | c
The expected output would be the events outlined in the following table, in which all events matching the first combination of session_id, object_id are allowed, when grouping by session_id.
Session_Id | Object_Id
x | y
x | y
a | b
a | b
... View more