Tag/Word Cloud

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

Preparation

Accepted answers

KaneG

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

WordCloudSetup.yxmd

All comments

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703