on 09-06-2011 4:31 AM
Hi,
I need to merge two files (Balance and transaction) with correlation is defined from ID, Date and Accountnumber..
Sometimes, when there are no transaction records, then balanace file will come up number "0"
Balance file:
-
MDk;1728;175;02.09.11;781961.09;0.00;0.00;781961.09;;;;;;;;;0
MDk;8574;175;02.09.11;4462;1112;104098800;104102150;;;;;;;;;2
from the above file, two accounts..
MDk;1728; --- with zero transaction record
MDk;8574; --- with two transaction records
Transaction file:
-
MDk;8574;175;02.09.11;;DEBIT;;;;;-1112;;0;02.09.11;;;;20555;;;037;
MDk;8574;175;02.09.11;;CREDIT;;;;;104098800;;0;02.09.11;;;;;;;099;
We are using Correlation to merge the files by using the fields (MDk;8574;175;02.09.11)
Now the issue is the BPM is not working as the correlation is not matching as the balance file consists of a row (with zero transaction record) which is not present in transaction file.
I have to ignore the first record in balance file as it contains 0 transaction data which means there are no records for this account in transaction file.
How can I delete those records before going to merge condition? Is there any thing i can do in balance file adapter?
Any suggestions please?
Thanks
Deepthi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Select Correlation value container as Multiline in BPM.
Check the Multiline CheckBox.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Deepthi,
Just a thought, why don't you handle 0 records in Mapping??
regards
Ramesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ramesh,
This is the problem at the first step of the BPM where we will receive the files.
Start> FORK (Rec1 & Rec 2)>TransforMap( Merge_to_targetfile )-->SendtoReceiver -->END
It is failing at step1 (Fork), where the files are not matching according to correlation condition which we set.
ie. ID, Date, Accountnumber.
As the transaction file doesn't contain the record "MDk;1728;175;02.09.11" which is present in Balance file, the correlation is not matching. Hence it is failed. It is not even reaching to map
As correlation is mandatory to receive two matching files, it is failing here..
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.