Skip to main content
Question

How to filter column data with regex

  • January 18, 2021
  • 1 reply
  • 25 views

Hello, I am trying to filter observations in particular column which begins with SYS or ENG while counting (Number KPI). How can I do it with Celonis? I have read about MATCH_PROCESS_REGEX, but did not quite get it. Please help

1 reply

  • Level 0
  • 128 replies
  • November 10, 2021

Hi @1460044418,

 

you could use SUBSTRING( ) to filter on the specific text string and then apply an analysis, sheet, component filter.

 

Hopefully, that helps solve that issue!

 

Best,

 

Justin