Dear all,

i have a sets of data A1 and A2 and sets of targets B1, B2.

A1 and A2 have same number of rows . records. I want to find ONE solution of a subsets of data set A would make sure

(Sum_subsets A1 = B1 and Sum_subsets A2 = B2)

as not always there is a solution, so if not possible minimize the differences, priority first to match B1 then match B2.

Does any Knime nodes allow for this directly?

If not possible, alternatively, I could simplify two sets of data into one. think of something manually give weights on target B1 and B2.

E.g. combined B Target = 90% * B1 + 10% * B2

Combine two columes of A1 and A2 ==> A = 90% * A1 + 10% * A2

like below

B = 90%* B1 + 10% * B2 = 3;

A (0.9A1 + 0.1A2)

-1

2

3

4

One soluation would be: include (4, -1) out of data set A, so the sum of both 4 - 1 = 3

Optimal (with minimal records) solution would be: include (3)

which nodes would be able to achieve this slightly easier problem?

Thank in advance, Ning