Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: The order of the fields

  1. #1
    Join Date
    Jun 2007
    Posts
    1

    Default The order of the fields

    Hello!

    I have to process very often the files sent by our clients, and I am trying to use Kettle to automate the process. Our clients send us text files containing 30 to 40 fields in average. Not always they came in the same order, but the field names are always the same, and some times they send us some fields we don't need at all.
    I created a transformation that processes the fields, using “text input file”, Modified JavaScript Value and lookup.
    My problem is: every time I receive the files from the client I have to modify the transformation – the order of the fields in the “text input file”
    How do I create a transformation that gives me the same result no matter the order of the fields in the input files?
    I played with the settings of “text input file”, but everything seems to depend on the order of the fields.
    Is this something that can be done through settings or I have to use scripting?

    Thank you so much,
    Angela

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

    Default

    You have to use scripting... personally I would tell them to always use the same format.

    Regards,
    Sven

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.