consolidate files and capture one row per file only

[PassION_es]

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.