Filling null values with mean in PDI (PENTAHO)

Question

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

Answer 1

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: