WHEN "XYZ Family Hospital" then "XYZ Hospital"
WHEN "Douglas Brockbank" then "D Brockbank"
This requires hard-coding values, of course, so if incoming values change, you'll need to maintain this calc.
The last line carries all non-processed values as their original value.
Use that calc instead of the original [Name] field.
I did create the CASE statement below as you outline, but got this error-
‘Expected type bolean, found string. Comparison in ‘CASE’ expression must be a bolean type.’
It’s correct that the example I provided are in fact strings, and so how would I convert my CASE statement to bolean?
Note, the [Name} field in the data warehouse is stored as a VARCHAR(30), and appears in Tableau as a ‘Dimension’
It has ‘abc’. However, the field with the ‘abc’ to the right of it contains MANY more values than I want. So preferable, I want to create a set called , which is a subset of values in , and then use the CASE statement for the new field.