Challenge #88: Counting Combinations
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
17 - Castor
01-21-2018
04:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
01-31-2018
02:07 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.


Then it;s a simple matter of using a summarise tool to count the unique object values.
TeePee
8 - Asteroid
02-02-2018
02:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
11 - Bolide
02-08-2018
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
CHarrison
8 - Asteroid
02-13-2018
07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kcgreen
8 - Asteroid
02-13-2018
02:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
8 - Asteroid
02-16-2018
09:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ozzy_Campos
8 - Asteroid
02-19-2018
11:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kelly_gilbert
13 - Pulsar
02-19-2018
12:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Spoiler
I totally forgot about the Concat action - I could have eliminated the crosstab tool.
Elena_Caric
8 - Asteroid
02-20-2018
08:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator