Possible Combinations

[JovanieYonson]

Hi, everyone.

I am currently trying to learn macro and would like to apply on this case. I have a sample dataset below where I would like to know the combinations of RecordID that when its Data are combined, it will contain all the numbers from 1 to 28.  (the field "Data" contains random numbers from 1-28)

Example of possible combinations: RecordIDs 7-8-9 or RecordIDs 7-8-10

I am interested in the minimum number of rows.

RecordID	Data
1	5,6,11,12,18,26,27,28
2	18,27,28
3	9,10,19,20
4	1,2,7,9,10,14,15,16,17,19,20
5	1,2,4,7,8,14,15,16,17
6	9,10,11,12,19,20,21,22,23,24,25
7	1,3,4,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,26,28
8	2,3,4,7,8,13,14,15,16,17,18,24,27
9	5,6,11,12,21,22,23,25,26
10	3,5,6,11,12,13,18,22,23,24,25,26,27,28
11	3,18,26,27,28
12	5,6,11,12,25

Any help is very much appreciated. Thank you so much.

[OllieClarke]

@RaphaelSilva That's a much nicer approach actually. Great Idea!

I changed my coefficient calc to be

Regex_CountMatches([data],',')

which matches you on 5,6,10

[RaphaelSilva]

In my formula tool I did the same as you, and added a +1 for completeness, but the weighting will be the same.
Happy to see it makes sense, thanks for sharing this tool, loads to learn using R Predictive tools

[JovanieYonson]

@RaphaelSilva @OllieClarke Good day! May I ask if the R Predictive tools is free? No more separate license during installation, right?

[RaphaelSilva]

It is quite heavy, so it does not come with the regular design installer, but you can use under the same subscription you already have for the designer.
https://help.alteryx.com/current/en/designer/get-started/activate-designer/download-and-use-predicti... 

[OllieClarke]

@JovanieYonson as @RaphaelSilva says it's included in the standard licence, but is a separate installer