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 |
@saachitalwar Something like this works for you?