Lower case issue

[Anonymous]

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

[sasikanth]

HI

use Capitalize() function

[tresesco]

Perhaps this:

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

[maxgro · Accepted solution]

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

[its_anandrjs]

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

[Anonymous]

Hi All,

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

But still issue persists

Regards

Neetha

[its_anandrjs]

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

[Anonymous]

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.