Hi Mohammed,

There is a PQL function called REMAP_VALUES and does exactly what You are looking for: https://celonis.cloud/help/display/CIBC/REMAP_VALUES

As an alternative, You can inverse filter the table for the activity "C" or use the component/sheet or even analysis filter so it excludes the Activity 'C' in Your analysis.

Hi Eral,

Thank you so much for your response.

I did have a look at the REMAP_VALUES PQL function but how do I get it to remap values in one table based on attributes of another connected table.

The use case or the idea is that we are trying to create different views for different business users. We do not want to remove an activity from an analysis or filter out cases containing that activity but rather based on a defined mapping for each user role we just want to remap some activity descriptions to NULL so that they do not appear in the process graph. I hope my question is more clear now?

Hi Mohammad,

I believe You can achieve this with a combination of CASE_WHEN and REMAP_VALUES:

help.celonis.cloud/help/display/CIBC/CASE+WHEN

Or even simply when the condition is met, then return NULL without the REMAPPING, you would still have to use a filter (of the null values) so they do not show in the output.