Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Read fixed file structure from a table

  1. #1

    Default Read fixed file structure from a table

    Hi! I want to read the structure of a fixed text file; actualy I have a table that contains name, lenght, position and format of each columns of a fixed file. How can I read from this table and makes the fixed files input step use the structure that I read?

    thanks!

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    dHi,
    The fixed files input step is not prepared for that.
    One possible approach is to read that configuration into variables. Then in your main transformation, read the file without separators (as a file with a single column) and parse the columns with JavaScript (by using those variables as reference),

  3. #3

    Default

    Quote Originally Posted by Maria Roldan View Post
    dHi,
    The fixed files input step is not prepared for that.
    One possible approach is to read that configuration into variables. Then in your main transformation, read the file without separators (as a file with a single column) and parse the columns with JavaScript (by using those variables as reference),
    Thanks :-D I'll do just like that!

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.