This content has been marked as final. Show 2 replies
I've a field name "UserLocation".
and data is Bangalore
' ' 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?