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

    Match Function

    Murali Srithar

      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?