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
B = 90%* B1 + 10% * B2 = 3;
A (0.9A1 + 0.1A2)
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