Forum Discussion
Word cloud visual how to use the Exclude feature?
Key column is required to make a relation for two or more tables. This requirement comes from from how SQL handles tables.
In other words, table must have primary kyes that might be use to join tables.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
So if you go back to Lazer's question. How are the keys 1 and 2 related to each other?
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.
Yes, I understand that. Thanks.
Can you give more insight into this question from above? "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."
Thanks,
Both table must have a Key (call it as you want) column that containse excluding words.
Rows will be contcatenated by key value.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
It does not matter how mmany words are in the tables. Tables must have key column with numeric indexes.
Tables should also have a relationship in Power BI that is built on the key column. This is a small hack to use both tables in a single visual.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi jason435
Could you solve your problem in the meantime?I have absolutly the same problem here and would be very grateful 🙂
Cheers
qwertzuiop
