It looks like you're new here. Sign in or register to get started.
In one attribute i have few document numbers remaing all are nulls. So i am trying to replace null by above document number like below attachment.
Please help me out.
I have a work around using R, so you can easily integrate into your pipeline with Execute R scripting extension
use the na.locf() function from the zoo package to carry the last observation forward to replace your NA values.
library(zoo)bz <- c(2,NA,NA,1,NA,1,4,5,NA,NA,NA,2)na.locf(bz)
Another possible option, within Rapidminer
In the time series extension, there is an operator for replacing missing values using various combination like previous value, next value, value(hardcoded) or linear interpolation.
I tried a simple use case and seems to do what you are looking for
Attached is the example data set and the process
You can download the extension from marketplace in your studio or from here
Please note that the "generate copy" is just for easier comparison if it is doing the right thing, you can ignore it in actual process