Free Trial

Alteryx Designer Desktop Discussions

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

removing duplicates as per latest date

Navya08
8 - Asteroid

Hi can someone help me in this?

I need to sort the data as per latest due date, which means i want to have data only with latest due date.. see excel sheet for reference

can someone help me to get this?

 

 

2 REPLIES 2
OTrieger
12 - Quasar

Hi @Navya08 

Use Summarize tool. Group it on the data that you need and the Set for Due Date Max.

Raj
16 - Nebula

@Navya08 
find the workflow attached
mark done if solved.

Labels
Top Solution Authors