check total records....
Summary
check total records and total amount against another csv fileContent
Hello,
we have latest OIC and have 2 csv files on ftp server.
file1 is data csv
file2 is corresponding control file csv ( one of the data here is TOTALRECORD followed by TOTALCUSTMERAMOUNT) for example it looks like 10, 10000
file1 has data for CUSTOMERAMOUNT. file1 has 10 records. Each record will have customer amount of 1000 that makes total out of 10 records 10000
Requirement is OIC to read both file1 and file2 and somehow total up the 10 records customer amount and check that this total matches the TOTALCUSTMERAMOUNT in file2. If it matches then well and good else we will send error email
0