The title is a little confusing, but basically I want to write a function like this:
CASE
WHEN `Track Split` LIKE '%AZ%' THEN 'AZ'
end
EXCEPT, instead of basing it off of a string, I want it to pull values from another column. I have a lot of changing data from row to row, so I want the row to check to see if the data contains a specific value from a separate column so I don't have to write a ton of different strings. Something like:
CASE
WHEN `Track Split` LIKE %`Library`% THEN 'AZ'
But that's clearly not working. Does anyone have any suggestions?