Hi gurus... I have to do some simple task but I don't know what to do... I need to get all combination (not permutation) of 2 values given a "group id" value I have this group idvalue1a1b1c2b2c2d And I want to have this group_idcombination1a b1a c1b c2b c2b d2c d I have to do this combinating 2 values by now, but it probably will be required combinate 3 values. I don't have a clue what to do, I don't even know what labels put to this post.... lol any help? Thanks in advice...

get all possible combinations of column values

Hi gurus...

I have to do some simple task but I don't know what to do... I need to get all combination (not permutation) of 2 values given a "group id" value

I have this

group id	value
1	a
1	b
1	c
2	b
2	c
2	d

And I want to have this

group_id	combination
1	a b
1	a c
1	b c
2	b c
2	b d
2	c d

I have to do this combinating 2 values by now, but it probably will be required combinate 3 values. I don't have a clue what to do, I don't even know what labels put to this post.... lol

any help?

Thanks in advice...

Common Use Cases

Join

Accepted answers

SeanAdams

another alternative is to do a self-join. Join this data-set to itself using the GroupID field.

I've attached a worked example to this post - with two legs. One includes duplicate combinations (like aa; bb etc), and the other filters these out.

If this solves the problem, would you mind marking this as solved - or if you have further questions, then it may be worth attaching a sample workflow with a mocked up data-set so that the community can help you out by completing the workflow.