Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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

Sudha8990AI
Astéroïde

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

quandai
Météore

Attached is my solution.

dpencheva
Astéroïde

Here is my solution. 😉

Inactive User
Non applicable

My solution:

Révélation
Challenge_88_JP.PNG
sumanthskumar
Astéroïde

Number 20

Révélation
sumanthskumar_0-1590041682335.png

 

balajilolla
Astéroïde
Révélation
Solution Attached

balajilolla_0-1590077320295.png

 

edavilac
Astéroïde

Sharing my solution, thanks for the challenge.

 

Révélation
Challenge_88_edavilac.PNG
NaiLo
Astéroïde

  

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Sharing my solution.

 

Révélation
Challenge_88_Emil_Kos.png
izamryan
Astéroïde

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!

 

 

Révélation

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