Alteryx Filter

[felixcaspari]

Alteryx Community,

I have what appears to be a fairly straight forward problem. I am trying to display the highest "Revision" for a given "Date" and "ID". 

The solution should be applicable to an Alteryx "Filter" as I want to funnel the data through my workflow (I will use the "T" output, but also want to keep accessibility to the "F" output). 

Please see the screenshot underneath- any helpful ideas would be appreciated.

[ponraj · Accepted solution]

Sample workflow as below. 

WorkflowTrue ouptuFalse output

[felixcaspari]

Ponraj- thank you for sharing. I was able to recreate the workflow on my end (please see attachment for anyone that might be interested in it)

Thanks,
Felix

[Ron_He]

My sample workflow as below:

Sample workflow

The result is as the following:

Results