Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 307 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 22 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Sorting alphabetically on name
Summary
Sorting alphabetically on name
Content
Hello - I have a sort on Candidate Name and I realized that names that are in lower case and names that have special letters (Polish letters) are dropping to the bottom/end of the list.
Has anyone else experienced this and is there a workaround?
Many thanks!
Regards,
Maria
Comments
-
I can't help with polish names, but for case issues EVALUATE('INITCAP(%1)', Table.ColumnName) , should do the trick
0 -
Thank you Rachel! I will try it!
0 -
Hello PB,
This is just a formula, you can use the formula editor to use it.
0 -
So I'm having problems. Was trying to use your formula for last name column from below. What am I doing wrong?
EVALUATE('INITCAP(%1)',["Candidate Personal Information"."Candidate Last Name"]
0 -
Square brackets
EVALUATE('INITCAP(%1)', "Candidate Personal Information"."Candidate Last Name")
0