Matching the sum of multiple rows to One Total (Batch payment to multiple invoices)

[tommykleinhans]

Hi All,

Is there a way to match multiple rows from one input of data to one row of another input of data based on the sum of multiple rows? For example:

1. Input #1 has the following records:

     a. $20

     b. $7

     c. $4

     d. $6

     e. $40

2. Input #2 has the following record:

     a. $33

Is there a tool that is cable of matching a, b, and d from Input #1 to Input #2? Thank you!

[ChrisTX]

Here are a few related posts.  I would like to try the Optimization tool mentioned in the last link, but I haven't had time.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multi-Row-level-Analysis/m-p/381960#M6...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/AlteryxGUI-exe-exception-when-processi...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Iterative-Macro-Efficiency-Too-Many-Ro...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Supplier-optimisation/td-p/445171

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Find-the-composition-of-a-number-from-...

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Finding-which-values-from-the-same-col...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Reconciling-transactions-find-...

Chris