Challenge #182: Word Sleuthing
- 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
Hey @AYXAcademy,
Is there a way to get a .yxzp made on 2019.2? My company is not quite on 2019.3 yet.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It seemed straightforward at first, even if using the Download tool.
But then the rabbit hole appeared and I jumped in. This text contained more than just a Sherlock Holmes story.
Aha!! So now I need to figure out which words belong to each book
Regex_Match FTW in a filter, to find the Start and End lines for each book. A formula tool with a smidge of Regex Replace pulls out the book title, and Start or End. Crosstab so the start and end are next to each other for each book. Append this all onto the original list, and tag with the book title when the Record ID fits between the start and end lines for each book. Filter where the book is empty.
Then the process of tokenizing per word, summarizing, calculating percentage, as above works. Just add a filter onto the end to separate the books out.
So much fun to play with this one!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Interesting Weekly Challenge. I received different set of result sets.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @cplewis90 :
Just download and open this package from 2019.2 Alteryx designer (File-->Open Workflow-->Browse this pc-->(Locate your workflow)). It will allow you to open with some warnings . Ignore those warnings and explore the data challenge. Even i use 2019.2 version. :):)
- 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
My first solution returned different results, so I started to exclude lines (all lines before "*** START"), but the results were still different. So I carried on exluding/including parts of the text and making the workflow more complicated ... and ended up with a simple solution matchig the expected output.
- 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
- 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