Challenge #88: Counting Combinations

[olivier_newman]

88

[MDestra]

Challenge #88:

[mjdrims]

Several years late but here is my solution.

[kstahly]

🤔

[ArisaOkada]

My fifteenth workflow!

[AMikha1]

Solved.

[jaroslav-tomcala]

Hi, I am not super proud of my solution, but here it is. I peeked into the official solution after this and couldn't believe how short it could have been.

Spoiler

[roopmathi]

Here is my approach:

Step 1: Apply a Transpose tool, choosing Data column( Item_Number_1 to Item_Number_8). Set a unique identifier as the Key Field (e.g., Transaction Number).
Step 2:Implement a Filter tool to remove any null values is the resulting rows
Step 3: Use a Sort tool to arrange the items names in the Value column Alphabetically A- Z
Step 4:Add a Summarize tool, grouping by the transaction number and concatenating the Value column. This makes sure there is 1 row per transaction_id and all the items purchased in the transaction are huddled together
Step 5: Use another summarize tool to count the number of unique combinations of same items (it's easier to compare because these are strings)

Spoiler

[SachinG]

Spoiler

[dinazulaikha18]

Use transpose, sort and summarize tools.