Filter out rows based on common values

[saachitalwar]

I have the following dataset:

Key	Status	Date
X	block	d1
X	ack	d2
Y	block	d3
Y	ack	d4

For the rows with common key, I want to separate the status based on earlier date

Like, X - if d2 > d1 then filter out the row

X

block

d1

Y

block

d3

[MilindG]

@saachitalwar Something like this works for you?