7 Replies Latest reply on Nov 28, 2016 2:00 AM by ra.sae.0

    Word Frequency - Textual analysis

    ra.sae.0

      Hi Team,

       

      I need help on making the below output from the input.

       

          Input

      TitleProduct IDPublish DateReaders
      Tableau BasicsA1123123
      Tableau AdvancedB1231245
      LOD Expressions BasicsQF12311244234

       

      I would like to do it in Tableau itself than doing it manually on excel or data source (My datasource is a Tableau server published data source).

      FYI. I have R installed too. We could try if any package can do it inside Tableau.

       

      output:

      WordTitleProduct IDPublish DateReaders
      TableauTableau BasicsA1123123
      BasicsTableau BasicsA1123123
      TableauTableau AdvancedB1231245
      AdvancedTableau AdvancedB1231245
      LODLOD Expressions BasicsQF12311244234
      ExpressionsLOD Expressions BasicsQF12311244234
      BasicsLOD Expressions BasicsQF12311244234

       

       

       

         I will use Count to get the below inside Tableau

      WordCount
      Tableau2
      Basics2
      Advanced1
      LOD1
      Expressions1

       

      Note: Below is a sample data. In Prod, we have like longer Title & Million records.