Skip to Content
0
Former Member
Jun 08, 2009 at 03:15 AM

File 2 Proxy Sync - BPM - Mapping

43 Views

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