1 Reply Latest reply: Jul 19, 2017 3:01 AM by Arnaldo Sandoval RSS

    Grouping in the Data Manager

    Dudley Diaz

      Hi,


      I was trying to group data from a collumn in the 'Add Field' tool and using an if statement and inside some or's. somehow the expression is not valid, but can't find the error. I applied it inside the app, and it works, so the syntax is ok, but not in the 'Add Field' tool.

      UsingOrInsideIF.JPG

      Can you help me?

       

      Thanks

        • Re: Grouping in the Data Manager
          Arnaldo Sandoval

          Hi Dudley,

           

          The expression's syntax for your field seems fine but it did not work for me when I tried locally, it does not like the ORs, then I tried a different approach, the WildMatch() function allows us to replace the ORs with a simple if-condition, like this:

           

          if( (WildMatch(Area__C, 'Marketing', 'Finance', '*nge*')),'WildMatch', 'Y')

           

          It works

          Buble-New-Field.png