Hi All,
This is my requirement , let me know if anyone has a solution for this.
I have 2 input files and I need to compare the total credit amount row in both the input files and if the amounts are matching then I should write the record into the output file as a single row.
INPUT FILE 1
005 CREDIT
010 CREDIT
015 CREDIT
TOTAL CREDIT AMOUNT1 : 123456.78
INPUT FILE 2
001 CREDITS
004 CREDITS
008 CREDITS
010 CREDITS
TOTAL CREDIT AMOUNT2 : 123456.78
OUTPUT FILE EXPECTED
TOTAL CREDIT AMOUNT1 : 123456.78,TOTAL CREDIT AMOUNT2 : 123456.78
Is this possible?
TIA
Regards,
Tesa