Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: XML-Input row-problem

  1. #1
    Join Date
    May 2008
    Posts
    9

    Question XML-Input row-problem

    I'm trying to use a xml as input (with a single xml-input object).

    The xml has the following structure:

    Code:
    <content>
    <headinfo></headinfo>
    <level>
    <g>
    <l1>
     <l2>
        <l2info></l2info>
        <rec>
          <itemA></itemA>
          <itemB></itemB>
          <itemC></itemC>
       </rec>
        <rec>
          <itemA></itemA>
          <itemB></itemB>
          <itemC></itemC>
       </rec>
     </l2>
    </l1>
    </g>
    <g>
    <l1>
     <l2>
        <l2info></l2info>
        <rec>
          <itemA></itemA>
          <itemB></itemB>
          <itemC></itemC>
       </rec>
        <rec>
           <itemA></itemA>
           <itemB></itemB>
           <itemC></itemC>
        </rec>
     </l2>
    </l1>
    </g>
    </level>
    </content>
    Target:

    l2info | itemA | itemB | itemC

    After a couple of hours of searching the right configuration I get only 2 records (the first two records).

    How can I recieve all records?

    If anyone could help me with this special xml-structure I would be truly gratefull.

  2. #2
    Join Date
    Dec 2005
    Posts
    531

    Default

    Hi,

    try the following transformation, of course you need to change the path to your XML file.

    The transformation uses the Get Data From XML (XPath) step. I think it only is available from 3.1.

    Greetings,
    Ingo
    Attached Files Attached Files

  3. #3
    Join Date
    May 2008
    Posts
    9

    Lightbulb

    Hey!

    This works fine! (After I upgraded to 3.1)

    Many thanks for your fast reply!!!


    tkkg
    Last edited by tkkg; 06-03-2008 at 05:54 AM.

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.