Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Mapping of German special chars in script not working

Hi,

I try to map region names from capital letters to only starting capital letter, e.g. 'NORD' to 'Nord'.

This is working fine in a QVW file, but doesn't work for 'SÜD' and 'SÜD-WEST' when using an external script for the code. There I still have both values in the data, SÜD and Süd. Anyone an idea, what might be the issue?

MAPPING

LOAD * INLINE [

    NL_DESC, NL_DESC_NEU

     NORD, Nord

     NORD-OST, Nord-Ost

     NORD-WEST, Nord-West

     OST, Ost

     RHEIN-MAIN, Rhein-Main

     SÜD, Süd

     SÜD-WEST, Süd-West

     WEST, West

     Zentrale, Zentrale

];

SF_TARGET:

LOAD Monat,

     ...

      ApplyMap('Correct', NL_DESC) as NL_DESC,

    

;

SQL SELECT

     ...

     NL_DESC,

FROM

<table>;

Thanks

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Mapping of German special chars in script not working

Try using Capitalize(), like:

Load

     capitalize(NL_DESC) as NL_DESC

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Mapping of German special chars in script not working

Try using Capitalize(), like:

Load

     capitalize(NL_DESC) as NL_DESC

View solution in original post

Highlighted
Not applicable

Re: Mapping of German special chars in script not working

This is working fine, thanks.