Forum Discussion

backuserichsen's avatar
backuserichsen
Frequent Visitor
4 years ago

Word Cloud

Hey, 

I am trying to creat a word cloud of Warrentt Buffet letter from 2021 (https://www.berkshirehathaway.com/letters/2021ltr.pdf) When i import the letter in to Power Bi desktop and try to split the words i can't seem to make it hapen. The issue is the words with small letters where there is no , or .. How do i split the words?

Need Help

5 Replies

    • backuserichsen's avatar
      backuserichsen
      Frequent Visitor
      4 years ago

      AllisonKennedy as you can see inn the wordcloud i get the ful colum when i applay the wordcloud. I can't seem to find out how to split the words in the column as they have more then one delimiter. And i am also not sure how to split words that has noe delimiter between them. 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi backuserichsen ,

         

        As far as I know, you can split column by delimiter.

        For reference:

        Split columns by delimiter

        For the value which has noe delimiter between strings, I think you couldn't split them automaticlly.

         

        Best Regards,
        Rico Zhou

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.