cancel
Showing results for 
Search instead for 
Did you mean: 

Getting Problem in Flat File to IDoc Scenario.

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Try out using Field6.field seprator ==='nl'

Edited by: Sainath Chutke on Jan 22, 2009 10:57 AM

Former Member
0 Kudos

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

VijayKonam
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thanks for ur reply...

But condition is that i want only single line with all six field.

VijayKonam
Active Contributor
0 Kudos

You are reading the file right.. it does not matter how looks in the XML..!!

VJ

Former Member
0 Kudos

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