We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #88: Counting Combinations

Sudha8990AI
8 - Asteroid

Good Exercise !! Learned more about the cross tab and transpose. 

quandai
7 - Meteor

Attached is my solution.

dpencheva
8 - Asteroid

Here is my solution. 😉

Jur
7 - Meteor

My solution:

Spoiler
Challenge_88_JP.PNG
sumanthskumar
8 - Asteroid

Number 20

Spoiler
sumanthskumar_0-1590041682335.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590077320295.png

 

edavilac
8 - Asteroid

Sharing my solution, thanks for the challenge.

 

Spoiler
Challenge_88_edavilac.PNG
NaiLo
7 - Meteor

  

Emil_Kos
16 - Nebula

Hi,

 

Sharing my solution.

 

Spoiler
Challenge_88_Emil_Kos.png
izamryan
8 - Asteroid

My first attempt to solve this I was going to use binary math:

 

I had columns set up, 1 for each of the 15 product types, and I was planning to just sum the values of the columns to get a string like : "001001001001001" to represent which products were bought.

 

Unfortunately I realised that binary math isn't a thing (!!!) and I realised there was an easier way to do this!

 

 

Spoiler

izamryan_0-1590173422645.png
Much easier to use the built-ins Tools this way