Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Formula step won't pass the results to the next step

  1. #1
    Join Date
    Dec 2012
    Posts
    18

    Default Formula step won't pass the results to the next step

    Hi,

    I was going through the Pentaho Data Integration beginner's guide and I was doing an exercise. It included the use of a formula step that calculates the fields from the input.

    I do believe that I was able to put in the correct details and correct formulas for each field (dividing the field by 20) but when I try to direct the output to a dummy, it shows the fields but not the answers. it shows blank cells on the fields that I just calculated and I am not sure why is that.

    I am sure the input source file is good because I clicked the show contents and it does have the contents. The log message does not help either which is "ERROR (version 4.4.0-GA, build 17542 from 2012-11-01 20.06.29 by buildguy) : Errors detected!"

    I have my files attached and the source

    examination.txtchap2examination.ktr


    Thanks,
    Simon

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

    Default

    In your first formula step you read an integer field (writing = 81) and divide it by 20 (4.05).
    You name the result "writing" - Kettle internally names it "writing_1" to avoid complications.
    And now you choose to copy the value to an existing field "writing", instead of adding "writing_1" to the output field list.
    Too bad, the value of "writing_1" requires a Number field type, while "writing" is of type Integer.
    Just change the field type from Integer to Number in your Text File Input step and merrily hop along.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Dec 2012
    Posts
    18

    Default

    Thanks for the help!

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.