Skip to Content

How to use REGEX_Match function in SAP HANA Calculated column.

-- Someone can please help me to solve this issue, Thanks in advance.--

I have scenario like this where "COL_NAME" Contains "(Major|Global|Named|Regional|Territory) (Account|Accounts|Sales) (Manager|Mgr))" then "YES" else "NO". This I want to create in Calculated field
This has to be work combination like if the column contains values like : Major Account Manager
Major Accounts Manager
Major Sales Manager
Major Account Mgr
Major Sales Mgr

Next --------------

Global Account Manager

Global Accounts Manager

Global Sales Manager .......etc

It has to work all the combinations as like given examples above. Please suggest me if it is there any relevant function which works.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 04, 2017 at 12:39 PM

    Hi Ramana,

    You can try the case function while creating the expression in calculated column.

    case("ROLE", 'Major Account Manager', 'Yes', 'Major Accounts Manager', 'Yes', 'Major Account Mgr', 'Yes', 'Major Sales Manager', 'Yes', 'Global Account Manager', 'Yes', 'Global Accounts Manager', 'Yes', 'Global Accounts Mgr', 'Yes', 'Global Account Mgr', 'Yes', 'Global Sales Manager', 'Yes', 'NO')
    Add comment
    10|10000 characters needed characters exceeded