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