Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Finding Unique ID's in a single day

Karthick461
8 - Asteroid

Hi,

 

 I have a table ( for example : Date and ID's are the columns). I would like to know how to find the unique Id's in a single day.. same ID must repeat in same day and other days.. but I need user ID to show only one time for one day... if next day has same user ID again means, then i need to show that as well..

 

Input:

Karthick461_0-1639985375579.png

 

Output I need is:

Karthick461_0-1639985648027.png

 

 

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Karthick461 
If I am not mistaken, it can be done by a unique tool.

1220-Karthick461.PNG

Labels
Top Solution Authors