Alteryx Designer Desktop Discussions

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

Find Unique Dates

bh1789
8 - Asteroid

I need to sort through the data and find only the entries where the dates are unique dates.  So in this file, I would want to ignore the entries with the date of 2023-02-01.  What tool would be suggested to do this?

 

Thank you,

 

A12023-06-07
A22023-07-07
B32023-02-01
B42023-02-01
B52023-02-01
B62023-04-14
C72023-05-12
C82023-06-05

 

2 REPLIES 2
apathetichell
19 - Altair

summarize tool - group by date count  filter - count =1. join date to date.

caltang
17 - Castor
17 - Castor

Visualizing @apathetichell 's solution:

image.png

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Labels