cancel
Showing results for 
Search instead for 
Did you mean: 

Delete the duplicate Items

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

RaghuVamseedhar
Active Contributor
0 Kudos

Jittu,

Please write UDF with below logic. Input is item1 queue/context.


LinkedHashSet<String> uniqueSet = new LinkedHashSet(Arrays.asList(item1));

        String[] uniqueArray = uniqueSet.toArray(new String[uniqueSet.size()]);

        for (int i = 0; i < uniqueArray.length; i++) {

            result.addValue(uniqueArray[i])

        }