Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!

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