pentahokettlepdi
Filling null values with mean in PDI (PENTAHO)
I have a xls input file and extracted mean using "Univariate Statistics" step; I tried to use "If field value is null" but I didn't figure out to replace the null values by mean from "Univariate Statistics". Can anyone help me with this? I am using Pentaho 8.3
Solution
Let do it with sample way:
Step1: calculate mean of value.
Step2: Add mean to main stream.
Step3: Replace null by mean value by Java Script (Script Value Step).
Here is my transform:
- Pentaho- How do I view the backend sql of reports?
- How to configure Pentaho Carte to accept HTTPS request instead of HTTP
- Pentaho/POI throws InvocationTargetException
- Git Not In Sync with Local Branch
- "RecursionError: maximum recursion depth exceeded" from ssl.py: `super(SSLContext, SSLContext).options.__set__(self, value)`
- How do I clear the cache in Pentaho Data Integration
- What is the difference between data integration softwares and ESB?
- Create a near real time DWH with Pentaho Community edition
- Set the charset for Firebird connection from Pentaho DI
- Pentaho Data Integration Community Edition 9.4 - Shared objects file feature of transformation doesn't support variable
- Pentaho Data Integration 9.3 - Postgres Incremental load
- How to find unique values from set of rows using pentaho kettle?
- How to add zero in front of single digit values using REGEX in pentaho
- Pentaho File Repository Moves Jobs & Transformations to root
- Use a field from a previous hop as a parameter in a Table input using Pentaho Kettle
- Pentaho kettle Can't run transformation due to plugin missing
- Waiting for Transformations in a Job
- Pentaho CDE: Is there a way to debug the sql command being executed?
- Pentaho Kettle replace cell value if value exists in other two columns
- How to find where KETTLE HOME is defined
- REST API calls through Pentaho Data Integration (Spoon)
- Pentaho PDI || Windows Current User
- Pentaho check if at least one row LDAP is 0
- Get row number from stream to perform concat
- How input data in line chart in Pentaho?
- Pentaho-carte rest api?
- How to run Pentaho transformations in parallel and limit executors count
- Pentaho to kill all running transformations if any one them fails
- Pentaho Business Inteligence Automation
- How to delete rows which were deleted in source table (Pentaho data integration)