Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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.

SUBMIT YOUR IDEA

Challenge #88: Counting Combinations

JyotiVG
8 - Asteroid

My solution 🙂

Spoiler
JyotiG_0-1629302467746.png

 

lolcott
7 - Meteor
Spoiler
lolcott_0-1629329754795.png

 

EdoardoAversaTIL
8 - Asteroid
Spoiler
Chal 88.png

zoya_asgari
Alteryx Alumni (Retired)

my solution

sebastian_klotz
7 - Meteor

My solution.

Ncardenas
8 - Asteroid

I opted for the data cleanse tool instead of the filter to get rid of the null values. I realized afterward that the reason my solution was not working was that I had not inserted a sort prior to concatenating and thereby was unable to count the unique combinations.

 

I tried to find a method using the formula and unique tool but had not figured it out and scrapped it. Will come back to this challenge again to find another way.

 

Spoiler
Ncajamarca_0-1629832687136.png

 

 

 

binay2448
11 - Bolide

My Solution....

KyronSmith
7 - Meteor

Another fun workflow!

MatthewBr
Alteryx Alumni (Retired)

Hint...Spin...and re-spin 

Spoiler
 
Vidya_Killivalavan
7 - Meteor

solution