Match Function

[MuraliPrasath]

Hi,

I've a field name "UserLocation".

and data is           Bangalore

                              Chennai

                              Hyderabad

                              '                '      this is null value it contains nothing.

I want to convert, this empty value into "Not-defined" value.

I've tried the following one 

pick(wildMatch(UserLocation,'* *','Bangalore','Chennai','Hyderabad'),'Not-defined','Bangalore','Chennai','Hyderabad') as UserLocation

but still I can't see Not-defined data in the UserLocation field.

Need Help on this?

[Kushal_Chawda]

try this

LOAD *,

if(len(trim(UserLocation))=0,'Not-Defined',UserLocation) as UserLocationNew,

.....

[sasiparupudi1 · Accepted solution]

if(IsNull(UserLocation),'Not-defined',UserLocation) as UserLocation

hth

Sasi