We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Case (Switch) or Case (If)

Received Response
45
Views
11
Comments
edited Mar 2, 2017 2:47PM in Reporting and Analytics Taleo Enterprise 11 comments

Summary

Cannot seem to get it correct

Content

Hi all, 

I am trying to create a derived field that inserts a new value based on an existing value. For example, we have companies that roll up into regions. We don't have a field for regions so I would to create a field that says if the company value is "Company 1", then "Region 1, else... I believe I am just missing something simple. Any help would be much appreciated. 

Below is what I am imputing. 

CASE "Requisition Organization"."Organization Level2 Name"
     WHEN ‘1000 SGWS Corporate’ THEN ‘Corporate’
     WHEN ‘1200 SGWS Corporate Services’ THEN ‘Corporate’

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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