The Inspire Cyber Monday promo has been extended to Dec. 1! This offer is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #11: Identify Logical Groups

Alteryx

attaching my solution

8 - Asteroid
Spoiler

10 - Fireball

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.

9 - Comet
Spoiler

A nice challenge, true to real-life use case scenario.  Thank you, @GeneR !

8 - Asteroid

I am working my way through the Alteryx Challenges as I am learning Alteryx. Here is my solution to the problem.

8 - Asteroid
Spoiler

8 - Asteroid

Here is my solution

7 - Meteor

Slightly trickier than I thought at first, but still pretty straightforward.

8 - Asteroid

Here is my solution to the challenge

8 - Asteroid
Spoiler