Sorting a list based on multiple criteria

RCern

I have a data set that I am trying to apply logic to and I don't know the best way to go about it.

Attached is a screenshot of an example set of the data.

If a Test Cycle has both "A" and "C" as the Status for the same "Type", I want only the row with the 'A" to appear.  The workflow can disregard the rows with C.  So in the example, for Test Cycle 21 since the "Type" Apple has both an A and C row, I just want the row A to remain.

For test cycle 34, they have two types, Apples and Bananas.  Since Test Cycle 34 has an A and C for Apples, just the row with "A" should appear for Apples.  For Bananas

, since just Status C appears, I want Alteryx to give me one row with the "C" and the max Canc Dt for those three rows for Test Cycle 34.

Is this easily doable in Alteryx?

test.xlsx

jrlindem

@RCern 

Hey there.  Yes, you can certainly do this.  I chose to use the Summarize Tool to help identify those Max(dates) and Min(flag) where the flag was created to handle the A vs C values to keep them "in order."  Here's the workflow.  Look at the attached as well for guidance on the formulas and summarizing.

Hope this helps!  -Jay

jrlindem_example.yxmd