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 :)
Solved! Go to Solution.