Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

Distinct Names & Unifying different letter case names

Hello!

I'm trying to create a filter with the function "first_last_name" to show the distinct names but also to unify when the names have different letter cases. So I have the name Randy Joubert then I have it again as Randy joubert and I need to combine them in some way. Is that possible?

Thank you!

1 Solution

Accepted Solutions
rupamjyotidas
Specialist
Specialist

user

capitalize(first_last_name) as first_last_name


or


Upper(first_last_name) as first_last_name

View solution in original post

6 Replies
dan_sullivan
Creator II
Creator II

UPPER(first_last_name)  then they will be the same and you can do a distinct on them

rupamjyotidas
Specialist
Specialist

user

capitalize(first_last_name) as first_last_name


or


Upper(first_last_name) as first_last_name

hammermill21
Creator III
Creator III
Author

Thanks Rupam, but I'm getting "Error in expression" 

rupamjyotidas
Specialist
Specialist

what is the expression you are using

hammermill21
Creator III
Creator III
Author

You were right, I made a mistake in my expression. Thank you!

hammermill21
Creator III
Creator III
Author

Thank you!