Challenge #11: Identify Logical Groups
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
Alteryx
05-07-2023
09:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
lucascs
8 - Asteroid
05-12-2023
08:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
tristank
11 - Bolide
05-16-2023
07:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Struggled conceptualizing this solution a lot. My original solution was not at all dynamic and I knew it could be better, so I went in and looked at some of the workflows people had submitted but didn't actually look at what the tool was doing. This gave me some new ideas for how to approach the problem dynamically. (More explanation in spoiler below)
Spoiler
I saw a lot of people using the append tool and realized I didn't have to parse the different reviews to look for the potential word. The second thing I realized is that I could use the summarize tool to find situations where multiple words existed within one review (as opposed to using a formula tool that would test all the different conditions and wouldn't be dynamic long-term) I took me a while playing with the summarize tool to achieve what I wanted, but I realized by grouping by the field and concatenating the buckets gave me the initial list of reviews and words that existed within the reviews. From there I had to do the reverse and group by the potential buckets and count the reviews that fell within those buckets. Very helpful for me when I realized how I could use the summarize tool to achieve something like this.

olga_strubbe
11 - Bolide
05-16-2023
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
MitchellBliesner
8 - Asteroid
05-16-2023
04:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
lucaskro
8 - Asteroid
05-18-2023
02:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Archie_bos
8 - Asteroid
05-22-2023
11:01 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
matthewblandford
8 - Asteroid
05-23-2023
11:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
MitchellBliesner
8 - Asteroid
05-27-2023
06:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
realdaniel1989
8 - Asteroid
05-30-2023
02:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator