Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Row Normalizer : Howto ??

  1. #1
    Join Date
    Oct 2009
    Posts
    14

    Default Row Normalizer : Howto ??

    Hi All,

    A question about row normalizer :
    I have an XML like this one :

    Code:
    <student>
       <inscription>
          <id>123456</id>
          <name>Joe</name>
       </inscription>
       <inscription>
          <id>123789</id>
          <name>William</name>
          <aaa>A1</aaa>
          <bbb>B1</bbb>
          <ccc>C1</ccc>
          <aaa>A2</aaa>
          <bbb>B2</bbb>
          <ccc>C2</ccc>
          <aaa>A3</aaa>
          <bbb>B3</bbb>
          <ccc>C3</ccc>
       </inscription>
       <inscription>
          <id>123987</id>
          <name>Jack</name>
          <aaa>A10</aaa>
          <bbb>B10</bbb>
          <ccc>C10</ccc>
          <aaa>A20</aaa>
          <bbb>B20</bbb>
          <ccc>C20</ccc>
       </inscription>
       <inscription>
          <id>123564</id>
          <name>Averell</name>
          <aaa>A100</aaa>
          <bbb>B100</bbb>
          <ccc>C100</ccc>
       </inscription>
    </student>
    And I should obtain something like this :

    id name aaa bbb ccc
    123456 Joe
    123789 William A1 B1 C1
    123789 William A2 B2 C2
    123789 William A3 B3 C3
    123987 Jack A10 B10 C10
    123987 Jack A20 B20 C20
    123564 Averell A100 B100 C100


    I'm working with row normalizer but without success

    Any help would be appreciated !!!

    Many thanks in advance

    Nicolas

  2. #2
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Hi.
    Maybe I'm wrong, but should you not use a "Get data from XML" input step?

    Mick

Tags for this Thread

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.