Word Cloud, Subfield, Not Exists and words to ignore
I am trying to load positive and negative sentiment phrases, using Subfield() to separate the words. I then want to throw out conjunction or noise words using an inline load of those words to "throw away". The result, in theory, would help generate a Word Cloud. I cannot seem to get the Where Not Exists(Positive, Noise) to work. I'll need to do it twice - once for the Positive statements and once for the Negative statements. This is what I have so far:
WordCloud_Sentiments:
Load SD_LOB as cloud_LOB, [Agent Type] as cloud_Agent_Type, [Agent Name] as cloud_Agent_Name, KeepChar(SubField(lower([Why Satisfied]),' '), ' abcdefghijklmnopqrstuvwxyz-') as "Positive", KeepChar(SubField(lower([Why Not Satisfied]),' '), ' abcdefghijklmnopqrstuvwxyz-') as "Negative"
Resident Merged_Table_1;
[words_to_ignore]: Load NOISE as ID1;
Load * Inline [
NOISE after all although an and are as at because before but can did do does even however if just lest now once only provided rather since so supposing than that the then though till unless until when whenever where whereas wherever whether which while who whoever why yet ];
TEMP: Load * Resident WordCloud_Sentiments Where Not Exists(Positive, ID1);
