Skip to Content
0
Former Member
Sep 04, 2009 at 09:11 AM

File to Idoc - Generate one segment where sourcfields have identical values

33 Views

Hello Team,

This is a Flat File to Idoc scenario where one idoc is generated at the target.

As i have mapped the Record(1..unbounded) with the E1MBXYI (1..9999), one record in the file would create one E1MBXYI- segment in the Idoc. So if the source has four records then this would create an idoc with four E1MBXYI-segments. The requirement is, it has to generate only 1 segment for the input records(Order,Item and Date) if they have identical values.

eg., 1234,66,01032009 (Order,Item,Date)

1234,67,01032009

1234,68,01032009

1234,69,01032009 - this would generate four E1MBXY1 segments in the target each for item value 66,67,68 & 69 as it has no identical item values.

eg., 1234,66,01032009

1234,67,01032009

1234,66,01032009

1234,68,01032009 - this would generate three E1MBXY1 segments each for item value 66,67 & 68 in the target.The 2 identical item values for item 66 creates one segment.

How could i achieve this in the mapping, Should i go for an UDF or could it be achieved using standard functions?

Appreciate your replies....

Thanks,

Rag