Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: filtering XML data for a specific parent node

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jan 2015

    Default filtering XML data for a specific parent node

    i'm quite a beginner with PDI and i'm now trying to use the Get Data from XML input to retrieve just a few field from some XML files, it's quite simple with the get fields for "simple" nodes but i fail if when i need to extract a specific value of a child when a parent node matches a condition, for instance given the XML below i'd just need to extract the value of CompanyId when the CompanyRole = Custodian

    i tried for instance using Xpath


    and tweaking syntax but always get kettle exceptions, grateful if someone could point to the proper Xpath expression
    thanks in advance

    <ShortName>Carmignac Securite A USD acc H</ShortName>
    Last edited by ciampa; 03-13-2019 at 07:17 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.