Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Importing the metadata of a flat file that has no headers

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Mar 2014
    Posts
    11

    Default Importing the metadata of a flat file that has no headers

    If we are importing a flat text file that has no headers, and no delimiters (with fixed-length data), and we happen to have the column names, column lengths, and datatypes in another file (for example, in an Excel file), can we import that information into the flat file transformation?

    In other words, can I import the info that goes onto the Fields tab of the Flat File Input, or do I have to type it all in? (I don't want to use the visual tool, using the divider bars, because there are too many fields and that is more error-prone.)

    Thanks.
    Last edited by DWalker07; 03-11-2014 at 06:24 PM.

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

    Default

    That goes by the name of metadata injection.

    You can find examples in your Kettle books, the Wiki, some blogs and in this forum.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Apr 2008
    Posts
    1,771

    Default

    Or you can always copy and paste!!
    If it's a one-off transformation, you can always copy/paste information from any step tabs into/from an Excel file.
    -- Mick --

  4. #4
    Join Date
    Mar 2014
    Posts
    11

    Default

    Quote Originally Posted by Mick_data View Post
    Or you can always copy and paste!!
    If it's a one-off transformation, you can always copy/paste information from any step tabs into/from an Excel file.
    Well, when the flat file has 260 columns, that's a little tedious. I will look up "metadata injection". Thanks.

  5. #5
    Join Date
    Mar 2014
    Posts
    11

    Default

    Quote Originally Posted by marabu View Post
    That goes by the name of metadata injection.

    You can find examples in your Kettle books, the Wiki, some blogs and in this forum.
    Thanks, that's the info I need. I will look it up.

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.