Finding all possible combinations of each value

[richard_gardner]

I'm struggling with how to solve the following problem: I have a list of id's and values. The number of values associated to each id can be as low as one and as high as 24. I need to create a list of all possible combinations of values for each id.  Below is an example of the input and the expected output. Any suggestions on how I could solve this?

Input

id	Value
1	17
1	552
2	17
2	58
2	120
3	120

Expected Output

id	Combo 1	Combo 2	Combo 3	Combo 4	Combo 5	Combo 6	Combo 7
1	17	52	17, 552
2	17	58	120	17, 58	17, 120	58, 120	17, 58, 120
3	120

[LiuZhang]

Good job @chukleswk, let's wait and see if there is more requirement about it. 

In the main time, suggest it to Alteryx challenges 😁

[chukleswk]

@LiuZhang I was thinking the exact same thing after I got through my first little attempt at it! I was going to sit don and run the whole thing with 28+ entries overnight to see how long it would actually take.

@richard_gardner if this works or you, then could you please accept @LiuZhang's solution so that others may find it!

[richard_gardner]

Thank you @LiuZhang and @chukleswk  for all of your help with this. No permutations are needed for my use case, so I wrapped this in a batch macro and it worked perfectly. Thank you so much!

[Hiblet]

For others who come looking for a general tool for working out Combinations, I have a macro up on the Public Gallery that will "pick k items from a list of n items" as a combination, using an MIT algorithm based on the fact that binary numbers are unique combinations of 1 and 0.  Find it here... https://community.alteryx.com/t5/Public-Community-Gallery/Combinations/ta-p/1023099

[Deepakchandrashekar]

@LiuZhang can you please help me, absolutely awesome macro. I have a problem statement on similar lines, but a small tweak

I am looking to create combinations based on groups

Attached is a sample where in I have 4 groups and associated numbers. not sure how I can use your macro to get them to give me combinations by group 

[Hiblet]

@Deepakchandrashekar Is this the sort of expected result...

I have not put the combinations into columns, as this format is easier to paste, and it is trivial to change the format, but the image should show the results clearly.

[Deepakchandrashekar]

Yes , @Hiblet

Basically looking to cover all combinations in a given group.

THank you for helping me out 

[Hiblet]

@Deepakchandrashekar Attached is an export of the flow.  The flow calls a batch macro, which in turn wraps my ComboMonster macro (available on the Gallery).  I basically pack each task for the ComboMonster into one record, and the batch macro pushes those packed records one at a time.  Beware putting data into this where you have 10 or more items in the group, as combinations become huge very quickly.

Quick Plug: I am a contractor for Continuum Jersey, we are a consultancy who specialise in Financial and Automation solutions, and we are strongly pushing into AI and how AI can be used today by businesses.  You might be interested in this ChatGPT connector...  https://community.alteryx.com/t5/Community-Gallery/OpenAI-ChatGPT-4-Completions-Connector/ta-p/11163...

[Deepakchandrashekar]

@hiblet thank you so much for this macro, I had to make some tweaks to suit my need... but it works like a charm.... 

on the AI solution, I will check with my company if we could access them and keep you posted..

[Hiblet]

Great, good to know that it is useful.  On the AI side, the ChatGPT connector is effectively just a wrapper to make calls to the OpenAI API endpoints, so if your company allows this, then the macro would be useful.  It is only a macro because this allows me to make the calls throttled, and to make repeated calls if the endpoint is busy.  Good luck, Steve.