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
Asteroide

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

quandai
Meteoro

Attached is my solution.

dpencheva
Asteroide

Here is my solution. 😉

Inactive User
No aplicable

My solution:

Spoiler
Challenge_88_JP.PNG
sumanthskumar
Asteroide

Number 20

Spoiler
sumanthskumar_0-1590041682335.png

 

balajilolla
Asteroide
Spoiler
Solution Attached

balajilolla_0-1590077320295.png

 

edavilac
Asteroide

Sharing my solution, thanks for the challenge.

 

Spoiler
Challenge_88_edavilac.PNG
NaiLo
Asteroide

  

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Sharing my solution.

 

Spoiler
Challenge_88_Emil_Kos.png
izamryan
Asteroide

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