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

Question

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 · Answer

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#M69956

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/AlteryxGUI-exe-exception-when-processing-400-fields-file/m-p/381795#M69938

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Iterative-Macro-Efficiency-Too-Many-Rows-to-Process/m-p/387402#M70964

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-a-list-of-numbers/m-p/589807#M130773

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Finding-which-values-from-the-same-column-added-together-give-me/m-p/1099693#M272786

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Reconciling-transactions-find-which-combination-equals-GL-line/m-p/1078379#M266859

Chris