Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx Filter

felixcaspari
7 - Meteor

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.

Filter_Question.png

3 REPLIES 3
ponraj
13 - Pulsar

Sample workflow as below. 

 

WorkflowWorkflowTrue ouptuTrue ouptuFalse outputFalse output

felixcaspari
7 - Meteor

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
5 - Atom

My sample workflow as below:

 

Sample workflowSample workflow

The result is as the following:

 

ResultsResults

Labels