Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Export resutl from "execute SQL Script" to "Microsoft Excel Writer"

  1. #1

    Default Export resutl from "execute SQL Script" to "Microsoft Excel Writer"

    Hi to all,
    How can transfer a result from sql scrpt to a file excel?
    I need "Select values" steps?
    Thanks

    Giorgio

  2. #2
    Join Date
    Feb 2016
    Posts
    9

    Default

    Quote Originally Posted by eusebio72 View Post
    Hi to all,
    How can transfer a result from sql scrpt to a file excel?
    I need "Select values" steps?
    Thanks

    Giorgio
    Table Input -> Microsoft Excel Output

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by eusebio72 View Post
    How can transfer a result from sql scrpt to a file excel?
    The result from a "Execute SQL Script" step will usually be something along the lines of "2 rows updated"
    What are you trying to accomplish overall? We might be able to explain things better, if you tell us the big picture.

  4. #4

    Default

    Thanks for your answer
    @rdudejr: now I try your solution
    @gutlez: I have a big query from SQL and I must transfer result in a big excel file and send it by mail (I just prepare the job with mail). So I have the problem to transfer result of query into Excel.

    Giorgio

  5. #5

    Default

    I resolved my problem. I create a view in Sql with my script and then in table input a call my view
    Thanks to all

    Giorgio

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.