Show all possible combination from 5 columns

[Felix776]

Hi Alteryx Users,

I have a column of unique data that consists of 33 rows. I would like create a list of all possible combination with 5 of these columns, based on nCr calculator I should have 237,336 possible unique combinations. Can I ask for some help how would I be able to achieve in alteryx? 

Many Thanks

0

1

2

3

4

5

6

7

8

9

A

B

C

D

E

F

G

H

J

K

L

M

N

P

R

S

T

U

V

W

X

Y

Z

[ashissanpui]

Use append fields tool from join tool with settings 

[Felix776]

Hi Ashissanpui,

Thanks for the response, I am very new to Alteryx.

I had a look and try but just can't get what I want.

Can you show me how to set it up please?

With 5 columns I would get something like

00001

00002

00003

00004

00005

00006

00007

00008

00009

0000A

0000B

0000C

0000D

0000E

.

.

.

.

.

.

.

G39FD

G39FE

G39FF

G39FG

G39FH

etc.

[ashissanpui · Accepted solution]

Attached.

Spoiler

[danilang]

Hi @Felix776 

Since you're looking for permutations with replacement "00001" your formula is PR(n,r) = n^r giving you ‭39,135,393‬ combinations

Dan

[Jonathan-Sherman]

Hi @Felix776,

I'm not sure where your 295k values came from as i had 39M records? The same as @danilang suggested.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[Felix776]

Thank you Ashissanpui, it is indeed should be 39,135,393 as it is a permutation.

Thank you very much again.

Sorry for the late response!

Felix