I have a field that contains a sentence such as "I love wonderful food!" I want to be able to check each word against a lookup table to determine if the sentence was positive or negative. I need to be able to track the count of each good and bad word and give the sentence a score. So for the above sentence the score would be +2.
Good | Bad
love | hate
Is this possible with a lookup table or would it potentially be easier to turn the entire event into raw text and search against a multi valued field?