community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Text to rows - every other word

Meteoroid

Hello all,

 

I'm working on a word cloud of common issues so have 30,000 or so descriptions of user issues.

 

It was easy enough to split into single words with a \s delimiter on the text to columns but I'd now like to split every two words (if easy enough I'd like to do every 3 words and so on).

 

Is there a way to do this with the default text to column tool ? I've tried \s(.*)\s as my delimiter but no luck.

 

Thanks,

Highlighted

While I expect you could come up with a convulted RegEx to do this (easy enough if you dont care about losing last word), I suggest:

 

2019-01-07_11-25-45.jpg

 

Split into rows word by word

Then use a multi-row formula tool to create a row id

Summarise the words back together.

 

This is then easy to adjust words per row by just amending the Multi Row formula

 

Sample attached

Meteoroid

Worked a charm, thanks!

Labels