Challenge #88: Counting Combinations

[NicoleJohnson]

My solution!

Spoiler

[LordNeilLord]

Originally I thought this was a Market Basket excercise, so if I bought Milk, what else was purchased with Milk...then I realised how stupid I was and re-worked my workflow! @ChristineB Market basket would be a good challenge one week

Spoiler

[ChristineB]

Great idea, @LordNeilLord!  In fact, @Joe_Mako had that same thought and his solution to this week's Challenge explores some possibilities with the Market Basket tools.  If you have some ideas as to what a challenge might look like for MB Analysis,  I'm open to all/any suggestions! 

[jamielaird]

Here's my solution.

Spoiler

[jamielaird]

Deleting a duplicate post

[JonM]

Spoiler

[SeanAdams]

Good fun & quick challenge 

Spoiler

[SeanAdams]

Good fun & quick challenge 

Spoiler

[estherb47]

Late in the game answering this challenge. My solution isn't unique. Fun, simple challenge, and great to learn that the concatenate function of the summarize tool ignores the Nulls!

Spoiler

Spoiler

The first summarize tool concatenates the items (in alpha order). The second counts the unique strings from the first.

[stubartmess]

A bit late to the game, but this is a fun first challenge. I look forward to trying many more in the future!