Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to execute a Sql Statement Select inside a field and get the select data?

  1. #1
    Join Date
    Jan 2017
    Posts
    1

    Default How to execute a Sql Statement Select inside a field and get the select data?

    I have a table with a field called 'query' containing 'select cdclient, nmclient, dtRegister from tb_client', and another field called 'parameters' containing 'where cdclient = 12345'.
    I created a new field called 'Sql' containing the concatenation of the 'query' + 'parameters' fields (forming a complete Select Sql Statement).
    Now I want to execute the Select Sql Statement inside the field 'Sql', get the return from select (the output fields) and generate an excel file.

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    That's funny ...

    Shout out if you need more help.
    So long, and thanks for all the fish.

Tags for this Thread

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.