You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Parse or Match specific string within a CASE statement

Summary:

A Dimension "Job"."job description" returns 'group1.group2.group3.group4'. All four groups are characters of varying length eg 'customer service.customer support.helpdesk.Manager'. How do I only match those that end in '*.*.*.Manager'?

Content (required):

NOTE: the above criteria is third logic check in case statement.

Thanks!

Mark.

Version (include the version you are using, if applicable):

23A

Code Snippet (add any code snippets that support your topic, if applicable):

CASE WHEN

"Job Requisition - Additional Details"."_PMP_" IS NULL  

AND  

"Job"."Job Family Name" IN ( 'Operations Support', 'Human Resources', 'Customer Experience')  

AND  

"Job"."Job Description" = 'Group1.Group2.Group3.Manager'   

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!