Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Table name like variable in sql query??

  1. #1
    Join Date
    Apr 2011
    Posts
    28

    Default Table name like variable in sql query??

    hello,
    I have two questions:
    1) What is the best way to get a list containing the names of tables and a transformation that goes through the list and then perform a SQL query (select * from %%tablename%%): excel, csv, xml or a table with the names of these tables? This list can be midified at any time

    2) can I do queries with variables on list of tables with different data schemas( a column more in the target table.)

  2. #2
    Join Date
    Dec 2009
    Posts
    332

    Default

    Lucky for you, we just worked through this exact process in depth. See this thread:
    http://forums.pentaho.com/showthread...b-for-each-row.

    In addition, the samples include a nice example:
    ./pdi-ee-4.1.2-GA/samples\/jobs/process all tables

    Please post up if you have any questions or run into any problems.

  3. #3
    Join Date
    Apr 2011
    Posts
    28

    Default

    thx, so much. I'll make a list .csv or .xls.

    regards

  4. #4
    Join Date
    May 2013
    Posts
    10

    Default

    Similar Question:
    What could be the right approach to make TableName as a variable when we select the table in TableInputStep?
    The variable holds a valid value.

    I have MySQL connection:
    SELECT * FROM ${Var_Name};

    But the above statement raises an error.
    What could go wrong here?

    Thanks in anticipation.

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.