The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Hello
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.
~*~*~*sample R~*~*~*~*
library(zoo)bz <- c(2,NA,NA,1,NA,1,4,5,NA,NA,NA,2)na.locf(bz)
~*~*~*END R~*~*~*~*
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
https://marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_series
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
Join us for a community conversation on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
