Challenge #88: Counting Combinations

[JosephSerpis]

Challenge Completed

[mceleavey]

This one comes up relatively frequently and is a really nice example in Alteryx of how easy it is to pivot your data.

Spoiler

I first transposed the data grouping by transaction so the objects were in a single column. I then filtered out the nulls and sorted by transaction and then object. I created a title field and cross-tabbed the data back using concatenate. This leaves each transaction in a single row, and all objects in a single cell sorted alphabetically.
Then it;s a simple matter of using a summarise tool to count the unique object values.

[TeePee]

Spoiler

This was a very interesting challenge for me as I kept approaching it as an Excel user and being frustrated that I couldn't easily sum across columns.  However, then I remembered about the Unique tool and deleted 80% of my workflow.  Very satisfying.

[SGolnik]

🙂

[CHarrison]

Pretty much the same solution as everyone else (Y)

[kcgreen]

I made a macro out of my solution for challenge #59 and was able to use that macro here.  

Spoiler

I concatenated all the purchases into a single cell per row.

The macro counts how many time each letter appears in the concatenated value and generates a code based on the counts of each letter

I used the summarize tool to count how many unique anagram codes appear.

[justin_winter]

We are working through some old ones in our Company's User Group and this is the one we tackled this week. Seemed pretty easy in comparison to most!

[Ozzy_Campos]

A lot of tools, but looks good.  

[kelly_gilbert]

Spoiler

I totally forgot about the Concat action - I could have eliminated the crosstab tool.

[Elena_Caric]

Done, had to go back and sort.  🙂