We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Date Filter based on condition

Gsiva3
8 - Asteroid

I have a Column with with content like, AA,BB,CC,DD and in column B I have multiple dates for the same entry in Column A i.e, AA value in column A have 3 dates in column B. 

Now the requirement is values in column A should get only the least date from Coulmn B.

Can someone help me out on this

 

Input
Column AColumn B
AA2001-12-23
AA2020-01-23
AA2025-03-21
BB2025-01-03
CC2024-10-16
CC2023-09-28
CC2022-06-30
CC2019-11-01

 

Output
Column AColumn B
AA2001-12-23
BB2025-01-03
CC2019-11-01
3 REPLIES 3
flying008
15 - Aurora

Hi, @Gsiva3 

 

FYI.

录制_2025_03_21_14_26_08_484.gif

Gsiva3
8 - Asteroid

Hi @flying008 

Thanks for sharing. Can you please share me the workflow which might be useful

flying008
15 - Aurora

Hi, @Gsiva3 

 

录制_2025_03_21_14_48_25_460.gif

Labels
Top Solution Authors