Grouping in the Data Manager

[#1]

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.

Can you help me?

Thanks

[ArnadoSandoval]

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