Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: XML Multi level Multi occurrence - how to?

  1. #1
    Join Date
    Dec 2007
    Posts
    5

    Post XML Multi level Multi occurrence - how to?

    I am using Spoon 3.0.1 XML Input step to read a file but I do not understand how to read the data.
    I have multiple elements of type X with id as attribute,
    Each X element contains multiple elements of type PROPERTY.
    Looking at the XML Input step I can read only 1 type of repeating element but I cannot read a repeating element within a repeating element. (see attachment of example.xml)
    It seems like it is lack the support of loop that resides within another loop.

    Any ideas how to do it

    Thanks
    rn



    PS
    I am also evaluating Talend and it's XML component is match more user friendly and worked great
    Attached Files Attached Files

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    You can get per Property element a row contaning the id, name and description in V3.1 using XML Get Data step.

    And we won't shoot you for using Talend

    Regards,
    Sven

  3. #3
    Join Date
    Dec 2007
    Posts
    5

    Default

    Sven thank for the info,

    do you know where can I get the getXMLData version for 3.0?
    The only version I could find support only version 2.4-2.5
    http://wiki.pentaho.org/display/EAI/...ation+Plug-Ins

    Thanks

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    It's no longer a plugin, it's now part of PDI (but only in 3.1). If you're adventurous you can build from SVN.

    Regards,
    Sven

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.