2 Replies Latest reply: May 31, 2016 3:53 AM by Murali Srithar RSS

    Match Function

    Murali Srithar


      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?