cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Alteryx Connect is now generally available! Find, understand, and trust all relevant information in your organization. Find out more.

Challenge #11: Identify Logical Groups

DE0413
Meteor

Challenge complete - similar solution to others :)

Spoiler
Week11Challenge.png
LordNeilLord
Alteryx Partner

Solution:

 

Spoiler
Weekly Challenge 11.png
A_Twa
Meteor

 

 

 

Awesome challenge; I took something of a 'brute force' approach to it.  :)

Spoiler
2017-06-30_11-36-52.png
nick_ceneviva
Alteryx Certified Partner

Solution Attached

KOBoyle
Alteryx Partner

Solution attached. Similar to others I used a Cartesian join and the FindString function. My stumbling block was getting the concatenated groups, which turned out to be quite simple once I saw that action was available with the Summarize tool.

 

Ken

Highlighted
vjoshi
Atom

I can't stop laughing after knowing solution is this simple. I used so many filters and formulas(to calculate intersections and then excluding it) in the end to get to the answer,