Challenge #88: Counting Combinations

[poojasrivastava]

Solved It 😎

[quinnserfass]

Finished!

[tristank]

Had me struggling for a while! 

[kdhdsny1]

[DavidYang]

Spoiler

[Eric_williams]

finished ann

[IsieDera]

Spoiler

[AndrewHoData]

Hi everyone!

Newbie here. I looked at the solution because this challenge befuddled me. Is someone able to explain why we would need to use the

Spoiler

Sort tool

even though the challenge advised the order did not matter?

I tried it without the tool and it gave me a count different to the solution. Just want to understand how it works!

Many thanks for your time and help in advance 😁

[Eric_williams]

To my knowledge it would matter. if you concatenate alteryx will read the row as one whole string. So you transpose the table. then sort so that any row that contained the same items will be in the same order. then concatenate and group by order ID.

[db]

My solution

Spoiler