topic Re: Lower case issue in QlikView

Lower case issue

Anonymous — Fri, 11 Jul 2014 08:40:19 GMT

Hi All,

Lower case issue - i have two excel files and retrieving a location column from 2nd file based on customerid.

First file column is named as CustomerID(Mixed case) and second file columns is named as LoginID(Mixed case).

so changing the case by using below lower string function in mapping load:

Lower(trim(LoginID)) as CustomerID

Below is apply map function:

ApplyMap('Location_Map',CustomerID,'Unknown Location') as Location

its changing all values to lower case,some customers are assigned 'Unknown Location' in application,even though the location column is populated in 2nd file for that customerid.

Please advise on the issue.

Regards

Neetha

Re: Lower case issue

sasikanth — Fri, 11 Jul 2014 08:44:20 GMT

use Capitalize() function

Re: Lower case issue

tresB — Fri, 11 Jul 2014 08:44:55 GMT

Perhaps this:

ApplyMap('Location_Map',Lower(CustomerID),'Unknown Location') as Location

Re: Lower case issue

maxgro — Fri, 11 Jul 2014 08:48:17 GMT

try to add lower (and trim) also in the ApplyMap

Re: Lower case issue

its_anandrjs — Fri, 11 Jul 2014 08:48:18 GMT

Use Lower case in both the fields other wise use Capitalize

Ex:- With Capitalize function

Capitalize(trim(LoginID)) as CustomerID

ApplyMap('Location_Map',Capitalize(CustomerID),'Unknown Location') as Location

Re: Lower case issue

Anonymous — Fri, 11 Jul 2014 08:57:26 GMT

Hi All,

Thanks for help,its reducing number of customers with unknown location from 175 to 130.

But still issue persists

Regards

Neetha

Re: Lower case issue

its_anandrjs — Fri, 11 Jul 2014 09:01:30 GMT

Use Trim both the fields or you can use Lower or Capitalize

Capitalize(trim(LoginID)) as CustomerID

ApplyMap('Location_Map',Capitalize(Trim(CustomerID)),'Unknown Location') as Location

Re: Lower case issue

Anonymous — Fri, 11 Jul 2014 12:23:13 GMT

Hi all

Thanks for help.

as said earlier it worked for some customers, i checked and others which are not worked are that login id column is empty.