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

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