Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Reading XML file one by one from a folder

  1. #1
    Join Date
    Apr 2011
    Posts
    4

    Default Reading XML file one by one from a folder

    Hi All,
    I have 5000 xml file in a folder,I want to read each xml file one by one.
    1) Read the 1st xml file.
    2) Extract the filelds.
    3)Concatentae them.
    Repeat step 1-3 till all the xml files in the folder are executed.
    Can anybody guide me on how to read the xml files one by one?

  2. #2
    Join Date
    Dec 2009
    Posts
    609

    Default

    Hi,

    there is a "Get File Names" Input Step, choose your source-folder, next use a "get Data from XML" step and create a hop from the first ("Get File Names") step to the XML-Input step...

    Cheers,

    Tom

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.