Databases
StackOverflow2013
Postsdbo
POPool numbers in a set of numbers to match the size of another set
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POPool numbers in a set of numbers to match the size of another set
    primarykey
    data
    text
    <p>I need to reduce the size of a set by combining the numbers in it. I need all possible combinations. Here are two examples that might illustrate my situation. </p> <p>1) Set1 has 4 entries and Set2 has 2. So we need to combine two numbers in each case. </p> <pre><code>Set1 = {70, 100, 50, 200}; Set2 = {"part1", "part2"} All combinations I want to retrive should look like following: "part1" |"part2" 70 + 100 | 50 + 200 70 + 50 | 100 + 200 70 + 200 | 50 + 100 100 + 50 | 70 + 200 100 + 200 | 50 + 70 50 + 200 | 100 + 70 50 | 70 + 100 + 200 70 | 50 + 100 + 200 100 | 50 + 70 + 200 200 | 50 + 70 + 100 70 + 100 + 200 | 50 50 + 100 + 200 | 70 50 + 70 + 200 | 100 50 + 70 + 100 | 200 </code></pre> <p>2) Set1 has 4 entries and Set2 has 3. So we need to combine two numbers just once.</p> <pre><code>Set1 = {70, 100, 50, 200}; Set2 = {"part1", "part2", "part3"} All combinations I want to retrive should look like following: "part1" |"part2" |"part3" 70 | 100 | 50 + 200 70 | 50 | 100 + 200 70 | 200 | 50 + 100 50 | 70 | 100 + 200 50 | 100 | 70 + 200 50 | 200 | 70 + 100 100 | 70 | 50 + 200 100 | 200 | 50 + 70 100 | 50 | 200 + 70 200 | 70 | 50 + 100 200 | 100 | 50 + 70 200 | 50 | 70 + 100 70 | 50 + 200 | 100 70 | 100 + 200 | 50 70 | 50 + 100 | 200 50 | 100 + 200 | 70 50 | 200 + 70 | 100 50 | 70 + 100 | 200 100 | 50 + 200 | 70 100 | 50 + 70 | 200 100 | 200 + 70 | 50 200 | 50 + 100 | 70 200 | 50 + 70 | 100 200 | 70 + 100 | 50 50 + 200 | 100 | 70 100 + 200 | 50 | 70 50 + 100 | 200 | 70 100 + 200 | 70 | 50 70 + 200 | 100 | 50 70 + 100 | 200 | 50 50 + 200 | 70 | 100 50 + 70 | 200 | 100 200 + 70 | 50 | 100 50 + 100 | 70 | 200 50 + 70 | 100 | 200 70 + 100 | 50 | 200 </code></pre> <p>I appreciate any help. I cannot think of any words to explain my concern better. But I will be very happy to answer any question. With you help I might be able to substantiate my question. Although the application is written in C# i don't necessarily need source code. My problem is rather the concept than the implementation.</p> <p>THANKS in advance!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USToby
    1. USToby
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POPool numbers in a set of numbers to match the size of another set
      1. USHamlet Hakobyan
      1. VTFavorite
    2. VO
      singulars
      1. POPool numbers in a set of numbers to match the size of another set
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POPool numbers in a set of numbers to match the size of another set
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSo, given a set `Set1`, and another set `Set2` of size `s`, you want to find all [partitions](http://en.wikipedia.org/wiki/Partition_of_a_set) of `Set1` into `s` parts, where **1** the order of parts matters, **2** the order of elements within a part doesn't matter, **3** the number of elements in each part is nearly equal.
      singulars
      1. POPool numbers in a set of numbers to match the size of another set
      1. USRawling
    2. COThank you very much for your effort so far @Rawling. Assumption **1** and **2** are right on. The number of elements in each part (**3**) do not have to be nearly equal. I rather want to get all possible combinations. Only empty partitions must be avoided.
      singulars
      1. POPool numbers in a set of numbers to match the size of another set
      1. USToby
    3. COOK; in that case you're missing 8 more lines in your first example :)
      singulars
      1. POPool numbers in a set of numbers to match the size of another set
      1. USRawling
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload