So I'm writing a simple case when statement where I'm renaming certain attributes:
when attribute_value ilike '%Sports Channel Value%' then 'Sports Channel Value'
when attribute_value ilike '%REF Sports Channel Value%' then 'REF Sports Channel Value'
else attribute_value end
And it's clustering the 2 renames into the same category when I recall them.
The reason why I'm renaming is each string will have .email day 1, .emailday3, .emailday5, etc etc so I want to roll up the naming to avoid having a messy output.