IÂ´m trying to find a solution using DFSORT for this problem but I can't find any function to solve it.
I have one dataset that contains information of initial balance and final balance of an account. The first column is the account number, the second column is the initial balance and the third column is the final balance.
On this example the second record are OK because the final balance of the first record is 0000000706570 and the initial balance of the second record is the same 0000000706570. The fourth record is wrong because it's initial balance (0001943580989) is different from the final balance of the third record (0001943580986).
What i need is to extract records where the initial balance is different from the final balance on the previous record.
Is possbile to compare data from the current record with data from the previos record using DFSORT, ICETOOL, etc.?