Keep only Unique Rows

ZoeM

Hello Community!

I have a simple one in illustration, but tough to implement for my level. 

In the attached, I have a very simple data set of phases a vehicle goes through, Stations 1 - 3.

If an issue is raised at a station, it is categorized as Uncontained.

If a raised issue has a solution identified at the station, it is categorized as Contained.

if a raised issue is resolved at a station, it is categorized as closed. 

At each station, for Closed issues,  I would like to keep it where it closed out. 

So in the sample, Station 1 had 1 Uncontained 1 Contained and 1 Closed.

Station 2 had 1 Uncontained 1 Contained and 1 Closed

Station 3 had 1 Uncontained 1 Contained and 1 Closed

uniquely to each station. 

As the issues go through the different stations theyre categories will change and I do not want to duplicate the results for when an issue was resolved (closed out).

I hope my explanation and desired results work?

Thanks in advance Team!

Only Uniques - Alteryx Community.xlsx

cplewis90

Hey @ZoeM,

I think I got what you are going for. I went through a workflow and not sure if you wanted an aggregation at the end, but you can always adjust that. Here is a picture:

Keep Uniques.yxmd