Skip to Content

Group, Sort and handle Duplicate XML records – using UDF

February 1, 2015 | 2,291 Views |
 Process IntegrationProcess Orchestrationudfxml
Follow

Below User Define Functions (UDF) logic can be used to group, sort and handle duplicate XML records.

Note: –

  1. Number of queue entries in each input field, to UDF should be equal (except key fields). Use ‘mapWithDefault’ for all optional input fields.
  2. Input fields context should be removed. Use ‘removeContexts’ OR right click on field and then change ‘Context’.
  3. Create UDF with Execution Type as ‘All Values of Queue’. Input all related fields to one ‘multiple input and multiple output UDF’. When match is found, write all related fields to output.
  4. Please tryout below examples in sandbox. And then solve your actual requirement.

Grouping XML records

Here is input XML and expected output XML: –

Grouping_TestData.PNG

Mapping: –

Grouping_Mapping.PNG

UDF: –

UDF will search ‘Name_People’ in ‘Name_Record’, if it finds a match, corresponding ‘Where’ and ‘Phone’ will be written to target fields with Context Change. Context Change will be added to output ‘Record_out’ for each ‘Name_People’.

Grouping_UDF.PNG

Sorting XML records

Here is input XML and expected output XML: –

Sort_TestData.PNG


Mapping: –

Mapping is same as above, add standard function ‘sort’ to key field. UDF logic is same as above. Output XML will be sorted with Name_People.

Sort_Mapping.PNG

Handling Duplicate XML records

Here is input XML and expected output XML: – Duplicate records are ignored.

Duplicates_TestData.PNG


Mapping: –

Dulicates_Mapping.PNG


UDF: –

HashSet will return true, if unique value is added. It will return false, if duplicate is added.

Duplicates_UDF.PNG

UDF code for reference


// Grouping XML records.
public void udf_getCorrespondingRecord(String[] Name_People, String[] Name_Record, String[] Where, String[] Phone, ResultList Record_out, ResultList Where_out, ResultList Phone_out, Container container) throws StreamTransformationException{
for(int i = 0; i < Name_People.length; i ++) {
     for(int j = 0; j < Name_Record.length; j ++) {
         if(Name_People[ i ].equals(Name_Record[ j ])) {
             Record_out.addValue(" ");
             Where_out.addValue(Where[ j ]);             Phone_out.addValue(Phone[ j ]);
             Where_out.addValue(ResultList.CC);    Phone_out.addValue(ResultList.CC);
         }
     }
     Record_out.addValue(ResultList.CC);
}
}
//If match has to be found using a combination of two fields. Please use logic something like this in above UDF:
//if((Name_People[ i ] + Where[ i ]).equals(Name_People[ j ] + Where[ j ]))
//------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
//------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
// Handle duplicate XML records.
public void udf_getUnique(String[] Id, String[] Name, String[] field1, ResultList Record_out, ResultList Id_out, ResultList Name_out, ResultList field1_out, Container container) throws StreamTransformationException{
Set<String> unique = new HashSet<String>();
for(int i = 0; i < Id.length; i ++) {
    if(unique.add( Id[ i ] )) { // True if unique.
      Record_out.addValue(" ");
      Id_out.addValue(Id[ i ]);                    Name_out.addValue(Name[ i ]);             field1_out.addValue(field1[ i ]);
      Id_out.addValue(ResultList.CC);   Name_out.addValue(ResultList.CC);   field1_out.addValue(ResultList.CC);
    }
}
}
To report this post you need to login first.

10 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member

    Good one Raghu Vamseedhar Reddy KadipiReddy


    Well, you don’t believe the same concept was in my mind from last few weeks for one of complex interface requirement which was recently go-live but at the moment with a java mapping and I am planning to replace it with a Graphical mapping for a better visibility in general and for enhancements by support team later

    May be you can consider adding below points,

    1. “Returning multiple ResultLists using an UDF” is not explicitly documented (at least I haven’t seen) in SAP help/Forum blogs etc..except we see this feature in standard SAP RFC lookup
    2. And using “Returning Multiple ResultLists” concept, we can replace some complex java mappings with a simple, effortless and efficient graphical mapping’s

    Thanks for sharing a nice pattern. And keep blogging your ideas ….

    Best Regards,

    Praveen Gujjeti

    (0) 
    1. Former Member Post author

      Thank you Praveen, for feedback.

      I myself written Java mapping for grouping XML records, previously. I agree with you, now we can implement more transformations using graphical mapping.

      (0) 
  8. Former Member

    Hi Raghu ,Thanks for sharing this it’s really helped me a lot.

    can you please tell this, for duplicate XML UDF. If I want add or concatenate the Field one . this is the requirement I got .

    Please share your thoughts

    Thanks

    Babu

    (0) 

Leave a Reply