multiple examples

RPattelaRPattela Member Posts: 8 Contributor I
edited November 2018 in Help


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.


  • Options
    dangdang Member Posts: 11 Contributor II

    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.

    ~*~*~*sample R~*~*~*~*

    bz <- c(2,NA,NA,1,NA,1,4,5,NA,NA,NA,2)

    ~*~*~*END R~*~*~*~*



  • Options
    bhupendra_patilbhupendra_patil Administrator, Employee, Member Posts: 168 RM Data Scientist

    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

Sign In or Register to comment.