Discussion Board for collaboration on QlikView Scripting.
I'm loading "County" from an excel file but the fields are either in UPPER or lower case (e.g. GREECE and greece) so they show as different countries in my app.
How do I normalize the fields after I've loaded data, without having to fix the source data?
Hi Nick, there are some strings functions to normalize the values like upper, lower and capitalize:
upper( 'abcD' ) returns 'ABCD'. --> all upper case
lower( 'abcD' ) returns 'abcd'. --> all lower case
capitalize ('my little pony') returns 'My Little Pony' --> first letter of eah word is upper case, the other lower case
First set all data to lower case and then Capitalize or Upper case:
Capitalize(lower(F1)) as Country;
LOAD * INLINE [