Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: multi-level xml creation

  1. #1
    Join Date
    Nov 2014
    Posts
    2

    Default multi-level xml creation

    Hey there all, I'm trying to teach myself how to create a multi-level xml doc from a sqlite db feed. I've been comparing what I'm working on to the "create multilayer xml" transformation for reference, but I'm just not sure where I'm going wrong. The error I'm getting is in the 2nd join...

    XPath statement returned no result [/Root/AVMInfo[@avmID=1]/Comparisons]

    AVMComparables.ktr


    Thanks in advance.

  2. #2
    Join Date
    Nov 2014
    Posts
    2

    Default

    I've cleaned up the transformation and added some xml files to see what is going on...

    AVMComparables.ktr

  3. #3
    njain111 Guest

    Default

    I cant tell what is wrong.
    But I would log results or do preview before this join to see if /Root/AVMInfo1/Comparisons exist in both streams.

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

    Default

    Quote Originally Posted by squib View Post
    XPath statement returned no result [/Root/AVMInfo[@avmID=1]/Comparisons]
    It's plain to see, that you never added an attribute avmID to element AVMInfo, so the error is to be expected.
    Perhaps you wanted to name the attribute avmID, that currently is named comparableID?
    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.