Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: XML join problems - HELP

  1. #1
    Join Date
    Feb 2012
    Posts
    4

    Default XML join problems - HELP

    Dear all,

    If anyone can tell the missing steps I haven't done.

    I encountered problems on XML join STEP,

    Attached screen dump for the compilation of the transformation of XML output.

    Not sure what is the correct Xpath statement value and the join condition field.


    P.S. One thing I tried, Source step and target step cannot have the same "column" for the comparison.

    I need to use another name in source step in order to show in "show ouput fields" !

    Thanks.
    Attached Files Attached Files

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

    Default

    Please, replace your table steps by data grids, so that we can see your transformation fail in the right places.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Feb 2012
    Posts
    4

    Default

    Dear Marabu,

    Attached data grids.

    Please help.
    Attached Files Attached Files

  4. #4
    Join Date
    Feb 2012
    Posts
    4

    Default

    Dear Marabu,

    I exported the transformation into XML output.

    You can import and see the details.

    Thanks.

    I wonder there is wrong setting in the XML join 3 step. ( Xpath statement and join comparison field )

    Or the target stream has more than one row.
    Attached Files Attached Files

  5. #5
    Join Date
    Feb 2012
    Posts
    4

    Default

    Dear Marabu,

    The word file xmlfail2 contains 2 XML steps output screen capture ( XML structures data contents )

    XML join 1 and XML join 2 , then use XML join 3 step to combine ( can be many invoices map to many invoices details )
    Attached Files Attached Files

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

    Default

    If you are looking for help, you must supply sample input data and the expected output.
    Table steps are not very helpful, since they require a particular DBMS on the other system.
    That's the reason why I asked you to replace the table input steps by data grids.
    So long, and thanks for all the fish.

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.