Dear Alteryx Community,
Good day,
Can you help me consolidate and captured only the ending balances of each dummy bank statement ?
For Bank 1,ending balance is located in 12th row:
Dumy Input filenames- 8521-0020-00 and 8524-0080-01
For Bank 2, ending balance has a unique word "Available balance" in the Narrative Column.
Dumy Input filenames- 0000-010000-111 and 0000-020393-888
Assuming I am dealing with multiple bank statement from these two bank so it is good to create a batch macro for consolidation.
Output will be the filename and the ending balances:
Dummy only:
| FileName | ENDING BALANCES |
| 0000-020393-888 | 860,983.50 |
| 0000-010000-111 | 1,267,457.42 |
| 8521-0020-00 | 28,400.00 |
| 8524-0080-01 | 2,258.00 |
Attached are dummy inputs and output file for your assistance.
Thank you.
