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