4 Replies Latest reply on Feb 9, 2016 6:22 AM by Shawn Wallwork

    Challenge - How do you count the occurrences of each word?

    Wilson Huang

      In a table of my SQL Server database, I have a field labeled [DESCRIPTION].

      This field (DESCRIPTION) is a free text field that can have any number of words. For example:

      ROW IDDESCRIPTION
      1"Sunday is Tableau Learning Day"
      2"Today is Sunday"

       

      Is there any way (preferably in Tableau) that I can use to count the number of occurrences of each word and report on it? Such as:

       

      I have limited access to the SQL Server and would like avoid going down this route if possible.