Alteryx Transpose Data and Split Words
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have some text I need to transpose and separate out the words with. Note some of the text can appear on multiple lines in the cell like.
"Sentence one.
Sentence two."
Here is my source data:
Here is my output:
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
So it looks like you don't need a transpose, but a Text to Columns set to Split to rows. To handle both a new line and spaces, we can configure the tool to handle both delimiters.
When ran, the output appears to give the desired results. I even threw in a couple examples where a few cells had new lines embedded.
Attached is a sample workflow for you to try.
If this solves the problem please mark answer as correct, if not let me know!
Cheers!
Phil
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Andrew_Seaman ,
See attached. You can use the text to columns tool and split by rows. \s is the delimiter for a space.
Thanks,
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MichaelSuand @Maskell_Rascal are 100% correct but there is a contingent of us who want REGEX answers -and only REGEX answers, for them, may I suggest adding a record id and a regex tool set to tokenize and split to rows. Field should be [text] and the formula should say:
([a-z]+)
(with case insensitive checked)...
Once more the chaotic\sspirits of REGEX have been appeased.
