Skip to Content
0
Jan 21, 2015 at 03:36 AM

Delete the duplicate Items

17 Views

Hi Gurus

source :

S1

Item1 : 123

Item2: ABC

Item3: 0000

S2

Item1 : 123

Item2: XYZ

Item3: 0000

S3

Item1 : 123456

Item2: YYYY

Item3: 0000

Have to delete duplicate segment based on the Item.

expected target:

Header 1

Item1 : 123 - ------------------>from S2 segment (S1 should not come because Item1 is same for S1 and S2)

Item2: XYZ

Item3: 0000

Header 2

Item1 : 123456

Item2: YYYY

Item3: 0000

Thank for help gurus.

Regards,

Jittu