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?

Filter Rows.yxmd