Forum Discussion
does excluding specific words exclude the entire cell value when using word cloud?
Hi Community, I'm seeking a bit of clarification here. I'm using the word cloud (wordcloud 1.7.1) visualiation to analyze customer comments in a given column. Because I'm only looking for hits on specific words, I'd like to exclude words such as "the", "and", etc. Now, I've managed to do that using the advanced filtering.
My questions is, if I filter out the those specific words, will the word cloud exclude all the other words in that cell? So in the example below, all comments in column B have the word "today". If I wanted to exclude "today", will the word still return all the other words or will I get zero results? My word cloud is quite large right now and I'm having a difficult time trying to determine if only the specific word is being removed or the entire cell. Thanks!
hi, Anonymous
After my test, Values in Exludes will match Values in Category, if two values are equal, the entire cell value will be excluded.
It can't be used to exclude specific words in Category Value,
for example:
in your sample data.
If you wanted to exclude "today", There's no row of data will be excluded.
but if you want to exclude "it will rain today", the entire cell of the third row will be excluded.
and if you want to exclude "today" for comment, you use replace in Edit Queries, like
beforeafter
Best Regards,
Lin
2 Replies
v-lili6-msftCommunity Support
hi, Anonymous
After my test, Values in Exludes will match Values in Category, if two values are equal, the entire cell value will be excluded.
It can't be used to exclude specific words in Category Value,
for example:
in your sample data.
If you wanted to exclude "today", There's no row of data will be excluded.
but if you want to exclude "it will rain today", the entire cell of the third row will be excluded.
and if you want to exclude "today" for comment, you use replace in Edit Queries, like
beforeafter
Best Regards,
Lin