Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Removing rows when a certain criteria is met

Highlighted
5 - Atom

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. 

 

UVIDTrade ReferenceStatus 
123ABCNew TradeREMOVE
456ABCCancelled TradeREMOVE
789DEFNew TradeKEEP

 

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

 

UVIDTrade ReferenceStatus 
123ABCNew TradeREMOVE
456ABCCancelled TradeREMOVE
789ABCNew TradeKEEP

 

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 :)

Highlighted
Alteryx Partner

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

 

2019-06-03 15_15_11-Alteryx Designer x64 - trades.yxmd_.png

Highlighted
5 - Atom
that's perfect! exactly what i needed - thank you so much!
Labels