Alteryx Designer Desktop Discussions

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

Filter for max date

ABHalpain
6 - Meteoroid

I am trying to solve for the following variations in my data set.  I need to filter rows to only keep the most recent effective date.

 

data sample and desired results are attached.

 

ABHalpain_0-1685752081636.png

 

 

Any Ideas would be greatly appreciated.

4 REPLIES 4
BRRLL99
11 - Bolide

BRRLL99_0-1685759874462.png

use summarize tool and group by column and Max date

no need to use select and filter tool

since your sample data has nulls and unwanted columns so i used select and filter tools

 

Dina
9 - Comet

Use the Summarize tool to figure out the Max Effective Date by EE, then use join to pull out the related records.

Dina_0-1685766712614.png

 

RSreeSurya
9 - Comet

Hi,

 

Attaching the sample workflow, using sort and summarize tool. 

ABHalpain
6 - Meteoroid

Thank you all!!!

Labels