Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Extra fields == variables?

  1. #1
    Join Date
    Nov 2007
    Posts
    22

    Default Extra fields == variables?

    Hi,

    I'm working with kettle this week at first, before I used another ETL tools. I'm trying to find in kettle similar funtionalities I used in other tools, that's why I want to ask you if exists one transformation or similiar to add new fields to the flow, I mean, you start with your input fields but sometimes you need extra fields to store some derived information, in kettle I have to use variables, or are there other ways?

    Another question, the way to define variables, is always using the kettle.properties file?

    Thanks in advance for your help.

    Regards,

    Ana.

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

    Default

    Quote Originally Posted by ansalort View Post
    Hi,

    I'm working with kettle this week at first, before I used another ETL tools. I'm trying to find in kettle similar funtionalities I used in other tools, that's why I want to ask you if exists one transformation or similiar to add new fields to the flow, I mean, you start with your input fields but sometimes you need extra fields to store some derived information, in kettle I have to use variables, or are there other ways?
    Most of the steps add additional fields to your rows on output, in javascript you can add them "explicitly".

    Quote Originally Posted by ansalort View Post
    Another question, the way to define variables, is always using the kettle.properties file?
    Via set variables/get variable step or setVariable/getVaribiable in javascript step ... but you can't set and use variables in the same transformation (then you need more transformations).

    Regards,
    Sven

  3. #3
    Join Date
    Nov 2007
    Posts
    22

    Default

    OK, thanks Sven for your helpful comment.

    It is difficult for me find the same functionalities in this tool, but with your help it is easier

    Regards,

    Ana

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

    Default

    Which other functionality are you looking for?

    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.