on 01-22-2009 5:56 AM
Hi,
I am facing problem which is as follows.
Test Flat File Contain Data As Follow
Field1,Field2,Field3
Field4,Field5,Field6
Field1,Field2,Field3
Field4,Field5,Field6
Field1,Field2,Field3
Field4,Field5,Field6
Source structure has only one segment with all six fields and is repeating.
What will be the file content conversion parameters so that it will pick first 2 lines and convert it into segment in this away.(I cant create two segments)
Thanks in advance.
Try out using Field6.field seprator ==='nl'
Edited by: Sainath Chutke on Jan 22, 2009 10:57 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I agree with Vijay.. so try to create the Data type like this..
Recoredset 0...1
-----Line1 0.... unbound
--------Field1 0...1
--------Field2 0...1
--------Field3 0...1
-----Line2 0.... unbound
--------Field4 0...1
--------Field5 0...1
--------Field6 0...1
Now do your FCC
Recordset Structure ---- Line1,*,Line2,*
Recordset per Message ---- 1
Line1.fieldNames ----- Field1,Field2,Field3
Line1.fieldSeparator ---- ,
Line1.endSeparator ----- 'nl'
Line2.fieldNames ----- Field4,Field5,Field6
Line2.fieldSeparator ---- ,
Line2.endSeparator ----- 'nl'
now map the fields as per your requirement.
Regards,
Sarvesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Define a recordset with to record strucutures.. line1 and line2. Specify parameteres for both lines. In the mapping recordset will repeat with line1 and line2. Map them to the idoc.
VJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
You dont need to do in the FCC but in the mapping, where you define Data Tyes as follows (Output is imported of course from R3 System):
Input DT Output DT
-
-
Line 1 - Field1, Field3, Field3 Segment1 - Field1, Field2, Field3, Field4, Field5, Field6
Line 2 - Field1, Field3, Field3
Then just map as follows
Field1-> Field1
.....
Field 6 -> Field6
Thanks
Damien
User | Count |
---|---|
88 | |
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.