Message Spliting Problem

30 Views

This is the follwoing source & target structures and i am using message split.

Source Structure is as fallows :

IDOC

Segment1 (1..Unbounded)

Field1

Field2

Segment_A (1..Unbounded)

Field3

Field4

Segment_B(0..Unbounded)

Field5

Field6

-

Filed 10

Segment_n(0..Unbunded)

Field11

-

Filed n

Target Structure is as fallows :

Record Set (0..Unbounded)

F1

F2

F3

--

Fn

We have to create a file per site.

In source structure Segment1 would present multiple times.Idoc would contain multiple sites data.The site value hold by Field6.If the idoc contains 3diffrent sites values then we have to generate 3 files.If the idoc contains same site data in diffrent occurences we have to collect the data from same site specific occurences and generate a file.

Suppose an idoc contain Segment1 for 3 times, The site values are AAA,BBB,CCC.Then we have to create 3 Files.

If the site values are like AAA,BBB,AAA then we have to create 2 files only.We have to combine the data for Site AAA and write a one file for Site AAA & one file for Site BBB.

Could any one give the suggestion on this regarding:)

All helpful answers should rewarded with points.

Cheers

Tiger Woods