Tag/Word Cloud

[HM]

Hi,

I'm currently importing a dataset from a Microsoft SQL server with multiple fields but I only want to use one of those fields (i.e. action field) to create a tag/word cloud in Tableau.

Some articles specify that the tokenize node should be used but I only want to break up the actions into words (stored in a single field) and filter out the common words before exporting it into a Tableau file - is this the right node to use?

Thanks,

Heidi

[KaneG]

Hi HM,

This would normally be done by breaking the field into individual words, hence the mention of the Tokenize node. You can either use the Text to columns tool on 'space', with split to rows selected, or the Regex tool with tokenize > Split to rows selected and '\s' as the Expression.

To work out the most popular words, you can then just use a summarise tool with Group By & Count, followed by Sort-Sample or Filter. I tend to also remove any words under 3 characters and have an exceptions list to remove words like 'again'.

Kane

[HM]

Thanks Kane.

Sorry I'm still new to this so I have a few questions - will all the words be stored in a single column/field? If the below was the input, could you please show me what the output would look like?

Action Owner	Action Created On	Action
A	1/1/15	Complete the template and send it to the appropriate team
B	1/1/15	Engage the reporting team for insights on past performance
C	15/2/15	Review governance model and communicate changes to the reporting team
A	1/1/15	Develop insights and reports
A	23/4/15	Create a word cloud report to identify themes

[s_pichaipillai]

hi HM

see the attached demo which will help you to strart with 

[KaneG · Accepted solution]

Hi HM,

Attached. This is set to remove words of 3 letters or less, but has options to exclude other words and include back in some automatically excluded words. You should be able to get an idea from this of how to set up the workflow.

Kane

[HM]

Thank you so much - it worked perfectly! 

[sj]

library(wordcloud) ListOfWords <- read.Alteryx("#1", mode="data.frame")$VectorOfWords AlteryxGraph(1, width=576, height=576) wordcloud(ListOfWords,scale=c(10,1)) invisible(dev.off()) This works too. IT's made from the r tool