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);
Drop Table words_to_ignore;
