Case and coalesce statement in one

[VijaySrrie]

Hi Team,

I have an auto-extracted field - auth.policies{}
I have another field called user 
Whenever auth.policies{} is root, I need that to be a part of user field
May I know how to do it? Is there a possibility to use case and coalesce together?

[gcusello]

Hi @VijaySrrie ,

yes, you can do it, but (as also @burwell said) I could be more detailed, if you could share your search.

Ciao.

Giuseppe

[burwell]

Hi can you say a little more about what the intended field values are that you are trying to achieve?