Alteryx Designer Desktop Discussions

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

Duplicates

Luk88kk
8 - Asteroid

Hello everyone,
I have a problem that I am currently struggling with. I have created a workflow that shows me duplicates. Now I have to leave only those entries that have the latest date, but in case the date is the same I have to leave only those for which the information comes from the System and not from the leaflet.

 

Input table:

Luk88kk_0-1645621110916.png

 

Output table:

 

Luk88kk_1-1645621181430.png

 

I am asking for your help.

 

 

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Luk88kk 

 

Does this work for you. If not provide more sample data.

 

atcodedog05_0-1645621576754.png

 

Hope this helps : )

 

binuacs
20 - Arcturus

@Luk88kk Another method

 

binuacs_0-1645624382648.png

 

mattnason1
9 - Comet

Here's how I would do it.

Luk88kk
8 - Asteroid

Thank you. At last I moved on.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Luk88kk 

Cheers and have a nice day!

Labels