Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: XML - Curious format..

  1. #1
    Join Date
    Apr 2007
    Posts
    2,010

    Default XML - Curious format..

    Hi,

    I have some XML like this

    <web>
    <node>
    <name>a</name>
    <instance><name>b</name></instance>
    <instance><name>c</name></instance>
    </node>
    <node>
    <name>d</name>
    <instance><name>e</name></instance>
    <instance><name>f</name></instance>
    </node>
    </web>

    And the row needs to look like this:

    Parent Child
    a b
    a c
    d e
    d f

    Now; When I loop on web/node it correctly gets all the child names, but the parent doesn't work correctly. in the above data I get:

    a b
    d c

    Hmm!

    Any ideas?

    Thanks,
    Dan

  2. #2
    Join Date
    Apr 2007
    Posts
    2,010

    Default

    Ah got it Loop on instance and set the node name to be "../name" Sorted!

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.