on 06-30-2015 8:33 AM
Hi guys,
I am doing an IDoc to File structure
Receiver FCC is a complex structure
this is the struture:
Segment1
Segment2
Segment7
Segment3
Segment8
Segment4
Segment5
Segment6
The client wants the output as a string without any field separators.
Initially I configured with "FieldFixedLengths", I got this error "field length not matching".
Segment two has close to fifty fields
I am using space as field separator and it's taken care of in mapping.
For ex: the seventh field of segment two has forty characters, but only ten characters value is populated. I will the remaing twenty nine fields with spaces and add the space mentioned in the FCC settings of CC
Eighth field has three characters, ninth has nine, and tenth has 2. These fields get respective values with sufficient length, so I am concatanating without spaces.
Everything is coming fine but when seven and eight fields are missing in segment two, the eighth field is shifted one position ahead.
How to take care of this? Does FCC actually support this nested structure?
Hi Harish,
You are saying that a field is shifting to different position. Are you mapping the missing fields with mapwithdefault function? Try it once.
Regards,
Suhale Shaik.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
One of he fields I am using
Field seven of segment two. It can either have value or no value
If there is no value send thirty nine spaces and the FCC add one more space and it meets the requirement of 40 characters
If there is value, then we count the number of characters in field and accordingly padd spaces with udf
If we have ten charcaters we padd 29 spaces and if we have four characters we padd 35 spaces.
Field 8, 9 and ten are always concatanated
At times when the field seven doesn't come in the structure we are getting only 39 spaces in the output.
This is the errror we are facing.
FCC is not adding the space when field is not there in source data
Field separator is "0x20"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.