Case (Switch) or Case (If)
SummaryCannot seem to get it correct
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’