cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to count non-unique names from a list in SAP Story

AshmiNayar
Discoverer
0 Likes
163

How to create a calculated column in a database which returns "Unique" if user ID appears once & "Not Unique" if it appears more than once?

I have a database with a list of user IDs. Here, a user ID may be unique or may be repeated. Is there a way I can add a calculated column to my query which returns "Unique" for those user IDs that appear once in the database and "Not Unique" for those user IDs that appear two or more times?

 

 

Accepted Solutions (0)

Answers (0)