Show all possible combination from 5 columns
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Use append fields tool from join tool with settings
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Attached.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
