Skip to Content

How to use REGEX_Match function in SAP HANA Calculated column.

Jul 25, 2017 at 08:02 PM


avatar image

-- 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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Manjunatha Kashirudraiah 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')
10 |10000 characters needed characters left characters exceeded