Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: XML Input Step: Creating Cartesian Product

  1. #1
    Join Date
    Oct 2009
    Posts
    8

    Post XML Input Step: Creating Cartesian Product

    Hi all,

    consider the following example document:

    Code:
    <data>
      <names>
        <name>A</name>
        <name>B</name>
      </names>
      <dates>
        <date>1</date>
        <date>2</date>
      </dates>
    </entry>
    I would like to create the cartesian product of all names and dates:

    row0: A 1
    row1: A 2
    row2: B 1
    row3: B 2

    Is there a way to get the job done with the Get Data From XML Step?

    Regards
    Flo

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Here you are
    Attached Files Attached Files
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Oct 2009
    Posts
    8

    Default

    Thanks for your reply (and the solution!).

  4. #4
    Join Date
    Oct 2009
    Posts
    8

    Default

    Thanks for your reply (and the solution)!

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.