Hi experts!
I have built few workflows earlier, but combination and nearest value match is something that I don't know much about it.
there are 2 different data sets like the below table:
| Data set 1 | Data set 2 |
| Legal.Entity.ID | Base.USD.Amount | Legal Entity ID | Base USD Amount |
| 830 | 4046642 | 830 | -1724333 |
| | | 830 | -8926592 |
| | | 830 | 10650925 |
| | | 830 | -6604283 |
| | | 830 | -2.7E+07 |
| | | 830 | 4370243 |
| | | 830 | 214050 |
i want to find out the combination of Base.USD.Amount in data set 1 from Base USD Amount from data set 2 (i have bold the numbers in data set 2 which sums up to the amount in data set 1) and get the combinations from data set 2 as output.
secondly, after doing the above condition i also want to check (for the rest of the data from data set 2) the nearest value. example shown in below table.
| Data set 1 | Data set 2 |
| Legal.Entity.ID | Base.USD.Amount | Legal Entity ID | Base USD Amount |
| 830 | 4046642 | 830 | -1724333 |
| | | 830 | -8926592 |
| | | 830 | 4046641.5 |
| | | 830 | -6604283 |
| | | 830 | -26706162 |
| | | 830 | 4370243 |
| | | 830 | 214050 |
i have bold the nearest value in data set 2 and that would be my 2nd output
Please assist if anybody knows how to do it.
Thanks,
Tanushree
