- Go to Transformation in the design mode
- Drill Down the Transformation folder and drag & drop the Calculator
-
- Double Click the Calculator Step a pop window same as below will appear
- In the New Field column name your new Field
- Select the type of calculation from the list box on the fields you want to perform calculations.
- Field A, Field B and Field C combos are available to select your fields that are need to be performed calculations
- Select the value type from the combo box and set decimal precision.
Labels
- AVG() Function (1)
- Aggregate Functions (1)
- Candidate Key (1)
- Composite and Compound Keys (1)
- EXISTS (1)
- FIRST() Function (1)
- Group By Statement (1)
- Having Clause (1)
- INSERT (1)
- LIKE (1)
- SELECT AS CLAUSE (1)
- SQL Distinct Unique Records (1)
- SQL IN (1)
- SQL Joins (1)
- SQL Last() Function (1)
- SQL NULL Conditional (1)
- SQL Not Exists (1)
- SQLComparison Operators (1)
- Sql Max() Function (1)
- Sql Min() Function (1)
- Sql SUM() Function (1)
- WHERE (1)
Blog Archive
-
▼
2010
(73)
-
▼
May
(40)
- Generate Mapping against target Step
- Pentaho Spoon Installation
- Group by SQL Query
- How to Insert Extracted Values in Pentaho Spoon
- Loading XML Data Using Pentaho ETL Tool
- SQL Query For Monthly Calculation
- Concatenation in Pentaho Kettle
- How to Split a String in pentaho Kettle
- Date to String Conversion in Pentaho Kettle
- How to get Distinct Count in Pentaho
- How to Write ETL Script in Pentaho
- Check Table Column Existence in Pentaho
- Performing Calculations in Pentaho Spoon
- Aggregate Functions in Pentaho Spoon
- What is Checksum in Pentaho Spoon
- Hex to integer Conversion in Kettle
- How to Set Environment Variables in Kettle
- What is Get Variable in Pentaho Kettle
- What is Set Variable in Pentaho Kettle
- Storing Transformations and Jobs in local Files Sy...
- What is Pentaho
- ETL Scripting with Open Source ETL Tools
- SELECT AS CLAUSE
- Calculations in SQL Query
- SQL Distinct Unique Records
- SQL IN, NOT IN and NOT BETWEEN Clauses
- SQL Between Clause
- SQL Multiple Conditional Queries
- SQL NULL Conditional Queries
- SQL Comparison Operators
- Candidate Key
- Super Key
- Composite & Compound keys
- Foreign key
- Alternate or Secondary Key
- Surrogate Key
- Unique key
- Primary Key
- Database Keys
- What Nomalization is?
-
▼
May
(40)
Wednesday, May 12, 2010
Performing Calculations in Pentaho Spoon


To perform simple calculations and get new fields on different output fields extracting from the database table on constant values.
Posted under :
Performing Calculations in Pentaho Spoon
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment