Skip to Content
0
May 03, 2014 at 03:49 AM

How to convert the flat file in to complex structure in graphical mapping

31 Views

Hi Friends,

could any one help me in achieving this complex structure, All the segments are 0-unbounded

Input structure is like this

RECORD(0-unbounded)

Segment 1

Field 1,Field 2,Field 3

Segment 2

Field 1,Field 2,Field 3

Segment 3

Field 1,Field 2,Field 3

Segment 4

Field 1,Field 2,Field 3

Segment 5

Field 1,Field 2,Field 3

Segment 6

Field 1,Field 2,Field 3

Segment 7

Field 1,Field 2,Field 3

Segment 8

Field 1,Field 2,Field 3

Output structure:

RECORD

Segment 1

Field 1,Field 2,Field 3

Segment 2

Field 1,Field 2,Field 3

Segment A

Segment 3

Field 1,Field 2,Field 3

Segment 4

Field 1,Field 2,Field 3

Segment 5

Field 1,Field 2,Field 3

Segment B

Segment 6

Field 1,Field 2,Field 3

Segment 7

Field 1,Field 2,Field 3

Segment 8

Field 1,Field 2,Field 3

I have an multiple records in input file

for sample input files see the attachment.

Thanks in Advance.

Attachments

Input.txt.zip (437 B)