on 02-19-2015 10:56 AM
Hi Experts,
I have a requirement to process the fixed length file. But records are not in sequence. When I try to process the file am getting below error in Communication channel.
I have attached sample file and the channel error screen shot. In this NY000010 is the Key for Header and NY000089 is the Key for Footer.
Same way NY090020, NY091030, NY091031and NY090088 are items. These items are repeating based on below sequence.
I have configured the channel like below.
Please guide me to solve. And let me know for further details.
Regards
Satya
Hi Satya,
If you need header and footer structures in the mapping you can use below.
RecordsetName = record
RecordsetStructure = rectype10,*,rectype20,*,rectype30,*,rectype31,*,rectype88,*,rectype89,*
RecordsetSequence = variable
Recordsets per Message = *
Regards,
Praveen.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Satya,
Please try
RecordsetStructure = NY000010,*,NY090020,*,NY090030,*,NY090031,*,NY090088,*,NY000089,*
In message mapping you can remove/ignore Record context.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satya,
If you dont require header and footer structures in the mapping you can do like below.
RecordsetName = record
RecordsetStructure = rectype20,1,rectype30,*,rectype31,*,rectype88,*
RecordsetSequence = variable
Recordsets per Message = *
Regards,
Praveen
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Satya
I think your file needs to be sorted in order for FCC to work.
The file should be in this format
NY000010 ...........
NY090020....
NY090020.....
NY090030
NY090030
NY090031
NY090031
NY090088
NY090088
NY000089
Or else the file should be in this format
NY000010 ...........
NY090020....
NY090030
NY090031
NY090088
NY000089
NY000010 ...........
NY090020....
NY090030
NY090031
NY090088
NY000089
Thanks,
Indrajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
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.