Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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