IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

trimming the duplicate values;;very urgent

  • 1.  trimming the duplicate values;;very urgent

    Posted Wed February 02, 2005 02:20 PM

    Hi ,
    I ma facing a strange kind of problem. I have an xml file in which there are many duplicate nodes.

    This is my xml file.


    module11

    New Swing Technology
    <?employees-employee-projects-project-technologies-technology-title swing?>


    XML StyleSheet Language for Transformations
    <?employees-employee-projects-project-technologies-technology-title XSLT?>

    12-oct-2004
    30-oct-2004


    module12

    New Swing Technology
    <?employees-employee-projects-project-technologies-technology-title swing?>


    XML StyleSheet Language for Transformations
    <?employees-employee-projects-project-technologies-technology-title XSLT?>

    31-oct-2004
    30-nov-2004


    module13

    Java Server Pages
    <?employees-employee-projects-project-technologies-technology-title JSP?>


    Enterprise Java Beans
    <?employees-employee-projects-project-technologies-technology-title EJB?>

    01-jan-2005
    30-jan-2005



    In the above xml I have to assignment elements with prj_id=SBBD and the other one is DPSIDSI.
    Now I should get the none duplicate values like SBBD and DPSIDSI and no.of distinct nodes as 2

    Can anybody send me the solution.

    Jithendar


    #webMethods
    #API-Management
    #Tamino


  • 2.  RE: trimming the duplicate values;;very urgent

    Posted Wed February 02, 2005 03:58 PM

    Hi,
    You can use the “Muenchian method” which is described >here<.
    I have attached a small example that works with your data. Maybe there are other solutions too?
    HTH
    Example.zip (1.05 KB)


    #webMethods
    #Tamino
    #API-Management