Help with generating combinations of letters

[estherb47]

Hi!

Don't know why I'm stumped on this one.

I have a list of unique letters, and I want to generate all combinations of letters

For example:

Letter

a

b

c

should yield:

Letter

a

b

c

ab

ac

bc

abc

Thanks!!

[DanS · Accepted solution]

The attached does what you want (ugly, but gets the job done)

I did a self join on a dummy "Group" and from there concatenated all possible combos that don't include identical letters.

From there I split them to rows in order to remove the duplicate pairs and did a bunch of grouping and concatenating with no delimiter.

Unioned back all possible combos including a combo of all original values at the bottom. 

Let me know if that works for you!

[sjm]

I found a Combination macro in the Gallery that might be helpful: https://gallery.alteryx.com/#!app/Combination/5602ee03a248970eac03bebf

"Generates combinations for a set of items.

ex. "a, b, c" generates "a, b, c, ab, ac, bc, abc"

Author: Alex Koszycki

Copyright: Alteryx, Inc. 2015"

[mborriero]

This simple workflow will generate combinations with lengths 1, 2 and N (Where N is the number of the letters given as input).

I hope this helps.

[mborriero]

This iterative macro does actually what you want.

Alex Koszycki

Alteryx, Inc.

Alteryx, Inc. 2015

[estherb47]

There are unknown tools coming up in this macro. I'm going to try to download the one from the Gallery

[mborriero]

Sorry my bad. Try it now.

[estherb47]

Thanks everyone, for your help so far. 

The macro from the gallery isn't working for what I need. It generates only an "a" and nothing more. I'll keep plugging away....

Best,

Esther

[estherb47]

this works, thank you! Now to turn it into an iterative macro that can handle from 1-n letters......

[mborriero]

Does this work for you?