Removing rows when a certain criteria is met

[estherchin]

Hi There,

I'm looking for some assistance in Alteryx to remove rows...

Basically i have trade data but i need to remove rows where a cancellation has occurred - i.e. 

UVID	Trade Reference	Status
123	ABC	New Trade	REMOVE
456	ABC	Cancelled Trade	REMOVE
789	DEF	New Trade	KEEP

There is also a situation where, if there was an amendment, i need to keep the last reference i.e.

UVID	Trade Reference	Status
123	ABC	New Trade	REMOVE
456	ABC	Cancelled Trade	REMOVE
789	ABC	New Trade	KEEP

in the second situation, we effectively need to keep the most recent UVID (i.e. the max)

I've tried using the unique tiling, but i just keep getting stuck!

Appreciate any help you can provide :)

[cmcclellan · Accepted solution]

I think this is what you're after .... 

[estherchin]

that's perfect! exactly what i needed - thank you so much!