Do word cloud cards have the capability to parse individual words from a phrase or sentence?

Unfortunately they don't, but I think that's a common enough request that Domo has it on their radar.  Make sure to have this on the Ideas Exchange if it's not already.  I also do know that, once upon a time, Domo consultants had developed a dataflow to do this parsing.  It's been a couple years since I saw that, though.  It wouldn't hurt to inquire with your consultant or success manager.

I'm trying to use this but on the first transform when I run the SQL it gives me the error:

'The database reported a syntax error. PROCEDURE word_cloud already exists'

Can someone help me out!?!?

Thanks!

 I'm getting the following error when I try using these instructions:

The database reported a syntax error. PROCEDURE dataflow_c7d35d3fc4104a2c87bb08f12b3880de.string_split does not exist

Are the instructions no longer valid?

Datamaven, I'm trying to work with this today (it must be in the air).  I'm having trouble with step 2.  When I copy/paste and modify the code as directed from call_transform_2.sql I'm getting an error. 

here's my code:

#Word Cloud V2
#Example: CALL word_cloud('sample_word_cloud_nolan', '`Sentence`' , 'y','y' );
CALL word_cloud('exp_word_cloud_input', '`RESPONSES_COLUMN`' , 'y','y' );

"The database reported a syntax error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1"

Are you able to assist or provide an example of how to get this MySQL dataflow working?

Wow what a journey that was to get it working... I ensured that blank and null values were stripped in my dataflow.  I then shortened my table names, in reality my table name was closer to 40 characters and my column name was 22 characters.  I shortened these down to about 10 characters each through renaming/data flows.  In the end I got it working and it had to be one of these things that enabled it to succeed.  Thanks for the vote of confidence that it could work @DataMaven , thanks to you, I didn't give up hope!

I did find this!

What I did was added the LOWER() function to the text field as my first step in the SQL dataflow.

UPDATE table_name SET sentences = LOWER(sentences)

I strongly believe it was shortening the name of the input table and the name of the column with sentences in it for step 2 of the SQL transforms down to <10 characters or so, all lowercase.  I also added a magic ETL step prior to this where I stripped out null and blank values from the sentences column.  (Filter for sentences_column IS NOT NULL and then does not equal Empty String)

I just made another one today and these steps seem to ensure it works.

Also be careful copy/pasting directly from the text in the help page... this code is shown and note the different single quote at the end next to the n character...

CALL word_cloud('survey_results', '`feedback`' , 'y','n’ );

@JasonAltenburg how big is your dataset?  using SQL to create a word document matrix is a little square-peg-round-hole-ish.

I built a tutorial around a similar topic here. 

http://www.onyxreporting.com/blog/domo-parsing-json-in-a-mysql-56-dataflow

the SQL is actually creating tables, but may not run as efficiently as the stored procedure, so it depends on the size of your database.

I haven't reimplemented this solution in Magic 2.0, but I suspect with a reasonable size dataset you could pull it off more efficiently than the MySQL pipeline and have a more transparent ETL.  Also implementing stop words would be a matter of having a table with a list of stop words and then JOIN and filter out the matches.

if you have python / r scripting, it'll be SO MUCH FASTER (i think).