I have a raw text file that is a database (1 record per row) - containing account numbers, dollar amounts, and other items. I would like to update this Text File Database with data from the line 'above' if the account numbers are the same for a new field - sample below
incoming
account# Check# CheckAmount Ending Balance
123456 12345 27.54 5987.62
123654 8761 14.34 890.65
123654 8765 87.55 817.44
123654 8790 101.23 803.76
123654 8801 914.12 9.13-
------------------------------------------------------------
outgoing
account# Check# CheckAmount Ending Balance New Balance
123456 12345 27.54 5987.62 5987.62
123654 8761 14.34 890.65 890.65
123654 8765 87.55 817.44 803.10
123654 8790 101.23 803.76 701.87
123654 8801 914.12 9.13- 212.25-
Can you do this in Abacre?