Create word cloud and use stop words through the "exclude" field

[qwertzuiop]

Hello dear Community

If I have a table with 1000 long form answers (sentences), and I create a table with stopwords. How do I setup key columns to link the two tables? The table inherently don't have any relationship to each other."

Cheers

qwertzuiop

[mahoneypat · Accepted solution]

I tried to do this with Word Cloud and was surprised it didn't accept columns from unrelated tables.  Two ways around this.

1. Make a relationship between your column containing the long text and the one with your stopwords.  Doesn't matter what kind of relationship, or if there are no matches.

2. Make a new blank query where you force those two columns in the same table with something like this.

= Table.FromColumns({StopWords[StopWords], TextTable[TextColumn]})

Then use the columns from this new table in your visual. 

#1 is easier, but I came up with #2 first so sharing both.

Regards,

Pat

[amitchandak]

@qwertzuiop , Can you share sample data and sample output in a table format?

You can have measure  like

calculate([measure], filter(Table,not( Table[word] in values(table2[stop word]))))

or

calculate([measure], filter(Table,not( Table[word] in allselected(table2[stop word]))))