check total records....

Summary

check total records and total amount against another csv file

Content

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