I'm not entirely sure if this is a combination or permutation problem, or something in between. I'm trying to figure out how to use Alteryx to enumerate all possible combinations of individuals to groups.
Let's say I have four people (A, B, C, D) to split into two equal groups. The group order or name doesn't matter, they just have to be separate groups. I think we could split them into three different combinations of two:
AB|CD ; AC|BD ; AD|BC
Obviously we can only use each person once. And because the group order doesn't matter, something like CD|AB doesn't count as a new combination because it's just the same as AB|CD. Hence the group order not being important.
If we had six people we could split them into three groups of two. I guess like this:
AB|CD|EF ; AC|BD|EF .... etc etc
How do I work out all the possibilities? And what if I had 12 people and wanted to split them into 3 groups of 4 people? Or 4 groups of 3 people? How would I go about enumerating all those possibilities? I can't quite get my head around it. Help required! There's probably a nifty little R function that can do this with one line of code, but help is required! Thanks
