SOLVED
Word frequency within text strings
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BigRuss
6 - Meteoroid
‎04-25-2018
02:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a csv file with a number of records with paragraphs of text stored as free text strings and I would like to search across all the entries in the column and produce a frequency table of the most used words within all the records
The effect I'm looking to obtain is similar to a word cloud with the most frequently used words given prominence.
I considered splitting the paragraphs up using the spaces as delimiters but that seems very messy. Anyone got a better way?
thanks!
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
3 REPLIES 3

Inactive User
Not applicable
‎04-25-2018
03:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Transpose to Rows and then use Text to Columns and Split to Rows on spaces. Then, summarise tool on the value by using Group By and Count.
‎04-25-2018
03:07 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Perfect, thank you!
nimit_b19
7 - Meteor
‎08-29-2019
12:55 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you please elaborate with words or with a dummy file?
