1 Reply Latest reply on Jun 16, 2019 6:53 PM by Rodrigo Calloni

    Most Frequent Word

    Mashael Ali

      Hello!

      I have many rows with a long text I need to find the most frequent 100 words in all rows.

       

      Thanks

        • 1. Re: Most Frequent Word
          Rodrigo Calloni

          Hello

           

          You will need to reshape your data. I suggest using Tableau Prep Builder for it.

           

          Basically you will need to split your column that contains the words on the space. Then you will need to pivot all the columns that the split generated to create a column where each word is a row. Finally you need to aggregate the data so that Tableau Prep gives you a new column with the sum of occurrences of each work (number of records).

           

          I hope it helps.

           

          Keep vizzing

          Rodrigo