Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Variable Filename + variable table name

  1. #1
    Join Date
    Apr 2009

    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


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


  3. #3
    Join Date
    Nov 1999


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

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


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.