Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Create a TABLE from Excel Input

  1. #1
    Join Date
    May 2013
    Posts
    8

    Default Create a TABLE from Excel Input

    Hello Every1,

    How can i create a table from taking the Excel input.
    Say, My excel coulms are Emp_Name and Sal.

    I want to create a temp table/table dynamically with the columns in the excel.
    Thanks & Regards,
    Deepak

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

    Default

    Although the Table Ouput step features a "SQL" action to generate the necessary DDL statement, no runtime execution of this code is provided.
    You can try to use that code in a User Defined Java Class.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    May 2013
    Posts
    8

    Default

    Quote Originally Posted by marabu View Post
    Although the Table Ouput step features a "SQL" action to generate the necessary DDL statement, no runtime execution of this code is provided.
    You can try to use that code in a User Defined Java Class.

    Thanku for the reply.
    I will check for that.
    Thanks & Regards,
    Deepak

  4. #4
    Join Date
    Feb 2011
    Posts
    840

    Default

    you could try using the excel input, metadata structure of stream Step to get the retrieved columns, and inject them on a transformation with a Execute SQL script...
    but that idea may need some more thinking and working, cause from what I remember, you'd need to specify previously how many columns there would be...
    Join us on IRC! =)

    Twitter / Google+ / Timezone: BRT-BRST
    BI Server & PDI 5.4 / MS SQL 2012 / Learning CDE & CTools
    Windows 8 64-bit / Java 7 (jdk1.8.0_75)

    Quote Originally Posted by gutlez
    PLEASE NOTE: No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.

    I'm no expert.Take my comments at your own risk.

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.