Hi Guys,
I am doing file 2 proxy sync interface. I am getting 2 files from 2 locations. First file contains group of records and second file contains the total records in the file 1.
File 1:
File :1
GroupNo InvoiceNo InvoiceDate InvoiceAmount
GD2000 XXX XXXXX XXXXXX
GD3000 XXX XXXXX XXXXXX
GD4000 XXX XXXXX XXXXXX
GD2000 XXX XXXXX XXXXXX
GD3000 XXX XXXXX XXXXXX
GD4000 XXX XXXXX XXXXXX
GD5000 XXX XXXXX XXXXXX
GD5000 XXX XXXXX XXXXXX
GD3000 XXX XXXXX XXXXXX
GD2000 XXX XXXXX XXXXXX
GD4000 XXX XXXXX XXXXXX
File 2:
GroupNo TotalRecords TotalAmount
GD2000 3 XXXX
GD3000 3 XXXX
GD4000 3 XXXX
GD5000 2 XXXX
Here, in file 1 GD2000 group having 3 records and in file 2, total records mentioned as 3. If in file 2, GD2000 total records mentioned as 2 then it should stop the process.
I have collected these two files by using BPM, i need help in designing the mapping for this condition.
Also advise me, whether i need to write a udf or not.
Thanks in Advance
Regards
Bala