ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

Emily_P
8 - Asteroid

Done!

uk_msmt
8 - Asteroid
Spoiler
uk_msmt_0-1612190623441.png

 

Eilean_
8 - Asteroid

rt

Slacker
8 - Asteroid

My Solution

OnionKnight
8 - Asteroid

This is really fun!!

TraceyD
Alteryx Alumni (Retired)

Here's my solution:

binu_acs
21 - Polaris
Spoiler
binuacs_0-1613054577683.png

 

Manonmani
6 - Meteoroid

Here is my Solution

Salvatore_Miseo
7 - Meteor

Goodmorning everyone,
below I have attached my solution.

Nice exercise. In solving it I followed almost the same solution, but I concentrated on creating the object list of the possible combinations, also concatenating the transaction ID's.

This exercise is very useful for solving cross-selling marketing research problems.

 

Challenge #88 Counting Combinations_SM.JPG

Airedelapaz
8 - Asteroid

I have a question/problem.  I have 19 distinct combinations.  I did not sort ascending after the filter step, as it appears that the file was already sorted in ascending order.  By excluding this step I end of up 19 instead of 12 distinct combinations.  Why is the sort necessary and how does it lower the distinct combinations from 19 to 12? 

Spoiler
Airedelapaz_0-1613332609368.png