- 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
at
8:21 AM
Posted by
M.Junaid Khan
0
comments
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