Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: XML from MSSQL

  1. #1

    Default XML from MSSQL

    Hello,

    I have developed an query using XML Path. Now i want that this is exported to an XML file.
    I tried Add XML, XML Output, Text file output but nothing seems to work.
    How can i do it?

    This is the XML:
    Code:
    <?xml version="1.0" encoding="UTF-8"?><AVXML><SIGNONMSGSRQ><SONRQ><ADMIN>JSVERK17</ADMIN></SONRQ></SIGNONMSGSRQ><EBUSMSGSRQ><EBUSTRNRQ><DUMMY></DUMMY><BUSOBJ>PG1</BUSOBJ><ROWMODRQ ALLOWADD="YES"><RECID>007102    1740184</RECID><COMMENT1></COMMENT1><DISP_INV>.F.</DISP_INV></ROWMODRQ></EBUSTRNRQ></EBUSMSGSRQ></AVXML>
    Thanks!

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    You can use text file output and disable Header in the Content tab

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.