Wednesday, May 12, 2010

Performing Calculations in Pentaho Spoon

0 comments
To perform simple calculations and get new fields on different output fields extracting from the database table on constant values.
  1. Go to Transformation in the design mode
  2. Drill Down the Transformation folder and drag & drop the Calculator
  3.    image
  4. Double Click the Calculator Step a pop window same as below will appear
  5. image
  6. In the New Field  column name your new Field
  7. Select the type of calculation from the list box on the fields you want to perform calculations.
  8. Field A, Field B and Field C combos are available to select your fields that are need to be performed calculations
  9. Select the value type from the combo box and set decimal precision.

0 comments: