Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Variable Filename + variable table name

  1. #1
    Join Date
    Apr 2009
    Posts
    2

    Default Variable Filename + variable table name

    I am trying to do this using Kettle:

    Step 1) Get input filenames using the get filename step ; Get the table name out of the filename using regex
    Pass each row of the step 1 to the next transform;

    Step 2) Read the input file (using the filename from the previous step). The input file is a csv file

    Step 3) Table output using the variable tablename from step 1

    I am able to reach upto the point where I get the table and file names.

    Problem Starts: The Table output matches the column names for input values. In our case , we won't have fixed column names since the filename is variable.

    Please help me with how to do this.

    - Thanks

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    There's not really a good way. PDI assumes that meta-data is "static".

    Regards,
    Sven

  3. #3
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    That is so true except when you program PDI to do this.

    http://wiki.pentaho.com/display/EAI/...a+API+Examples

    Perhaps we should consider creating some sort of scripting language for this sort of thing.

    Matt

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.