I’m working with a dataset that apparently contains some testdata. However, the case names of these test cases are not named consistently, e.g., some are named ‘test 123’, ‘TEST BV’, ‘test upgrade’, ‘20192406 test’, etc.
Is it possbile in some way to filter these cases out within Celonis? So, for example by applying a CASE WHEN statement checking whether or not a specific substring (‘test’ for example) in in the case name? Of course, we could check this if the naming is consitent by just using the SUBSTRING command, but this only works if you specify the starting point of the substring which we don’t know.
Hope that someone can help.
Thanks in advance,