String Calculated Field - Conditional Categorization

tableaucommunity@tableau.com — Thu, 04 Dec 2014 01:16:20 GMT

I need help figuring out how to count the instances of a word within text strings but not limit it to just counting an entry once such as when I use the IF THEN ELSEIF formula. See example below:

Sample entries

Text String	Sentences
The bridge that the fox jump is yellow	1
The quick brown animal jump over the bridge.	1

If I use the following calculated field (and the order matters)

Calculated Field: Text Search

IF CONTAINS([Text String],"Fox" ) THEN "Fox"

ELSEIF CONTAINS([Text String],"Bridge" ) THEN "Bridge"

ELSEIF CONTAINS([Text String],"Yellow" ) THEN "Yellow"

ELSEIF CONTAINS([Text String],"jump" ) THEN "Jump"

ELSE "" END

If you do a count of how many times the words show up with the elseif logic, it is sequential so it would count Fox first and then when it's done it goes to the next so it only shows up as this:

Text Search	Sum of Sentences
Bridge	1
Fox	1

Is there a way that it would show the following?

Text Search
Bridge	2
Fox	2
Yellow	1
Jump	2

--------

Post script:

Related to this is a product feature idea for Text mining ability in Tableau. Click here and vote it up: http://community.tableau.com/ideas/3069

Content in Tableau Community Forums

String Calculated Field - Conditional Categorization