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

Reply
Highlighted
Yellow Belt

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

In my dataset, I have full sentences as commentary on a question and I would like the word cloud card to parse out each word in the comments and aggregate a count of most commonly cited words. Do word cloud cards have the capability to parse individual words from a phrase or sentence, aggregate and then provide a count? I would love to be able to then click into a given word and read all of the comments that include that word.

Tags (1)

Accepted Solutions
Highlighted
White Belt

All Replies
Highlighted
Black Belt
Black Belt

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.

Aaron
MajorDomo @ Merit Medical

**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Highlighted
Yellow Belt

Thanks! That's what I was afraid of.

 

I'll be sure to add it to the ideas page!

Highlighted
White Belt
Highlighted
Yellow Belt

You, sir/maam, win the Domo-net today! Thanks!

Highlighted
Yellow Belt

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!

Highlighted
White Belt

When I followed the instruction in https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Word_Cl..., I came across this error: 

 

"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"

 

Can anyone help?

Highlighted
White Belt

 

 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?

 

Highlighted
Black Belt

Anyone still looking for this on this thread - this just helped me.  Scroll down for the code to handle phrases.  

http://knowledge.domo.com?cid=wordcloud

 

 

DataMaven
Breaking Down Silos - Building Bridges
Check out my video!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Highlighted
Green Belt

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?

Tags (1)
Announcements
Domopalooza 2021 Call for Presenters: We want to hear how Domo is revolutionizing the way you do business!

Click here to submit your story.