Hi all,
Recently, I've learned to account for duplicates and picking most recent dates, etc especially by this thread: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pick-the-record-with-most-recent-date/td-p/432507
However, now I am trying to account for duplicates but it cannot be solved simply by sorting on a date field. There is one column (or combinations of multiple) as seen in the attached image that I need to account for duplicates through. For example, I'd like to only keep the account numbers that are Remote and past the interview stage (so Interview and Offer Accepted). Another example would be only keeping the row that has the "Phone" type. There are many different ways to combine the statuses but that is the main point.
How do I account for duplicates by categorical statuses? On top of that, if there are certain hierarchies in those statuses like New-->Interview-->Offer-->Offer Accepted how can I establish logic in a way that I can easily filter on them like between Offer/Interview stage, Before Offer stage, etc.? Any advice would help thank greatly!
