Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Need to generate XML file

  1. #1

    Default Need to generate XML file

    Hi Everyone,

    I need a help on creating XML file from database view.
    View contains data in attached file.
    Required XML file is in following format.

    <DEPTINFO>
    <DEPT>
    <no>10</no>
    <deptname>MFG</deptname>
    <employees>
    <employee>
    <name>ABCD</name>
    <no>1</no>
    <sal>1234</sal>
    </employee>
    <employee>
    <name>XYZ</name>
    <no>2</no>
    <sal>2345</sal>
    </employee>
    <employee>
    <name>HYD</name>
    <no>4</no>
    <sal>2356</sal>
    </employee>
    </employees>
    </DEPT>
    <DEPT>
    <no>11</no>
    <deptname>ABC</deptname>
    <employees>
    <employee>
    <name>JKL</name>
    <no>3</no>
    <sal>4567</sal>
    </employee>
    </employees>
    </DEPT>
    </DEPTINFO>

    Sample XML file has been attached.Any help in this is appreciated.

    Thanks in advance.

    Thanks,
    Vinay
    Attached Files Attached Files

  2. #2

    Default

    if i understood what u want, u should use kettle!

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.