Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

check total records....

edited Feb 19, 2020 8:36PM in Integration 4 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!