It’s not clear to me how the column “Cases”.“LocalMarket” is structured. It seems likely to me that it contains a list of country names, separated by some kind of symbol like a comma.
The solution I’ll present here assumes the values look like this like ‘Spain,Germany,USA,…’
CASE WHEN “Cases”.“LocalMarket” LIKE ‘%,Spain%’ OR
“Cases”.“LocalMarket” LIKE ‘%Spain,%’
THEN "Cases”.“VendorName” ELSE NULL END
To explain: for Spain not to be the only country then another country must be listed before or after it, that means the separator symbol must come immediately before or after it. Two conditions using “LIKE” are therefore needed one with the separator before Spain and once after it. If it’s in the middle of the list, then both are true which is fine. The ‘%’ in the like condition can stand in your any number of characters.
If your column uses a different separator (e.g. a semicolon) just swap the commas in my code for that symbol. Another potential issue is that the code assumes that there are no spaces (’ ') between the country names. If there are just use ‘%, Spain%’ instead.
I hope this solves your problem If it doesn’t please reply with a screenshot of a table containing “Cases”.“LocalMarket” so that I can have a look at the structure.