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.
You can still use this function in SQL scripts, and insert SQL codes into RapidMiner for in-database SQL execution. (need “Read Database” or “Execute SQL” operators)
In rapidminer you can combine several operators for the same operation. For example, “Filter Examples” to remove the missing values (NULL), and then “Filter Example Range” to pick the 1st element.
I am attaching the example process here. Let me know if you have further questions.
Example with the Labor-Negotiations dataset and Generate Attributes:
if(missing([wage-inc-2nd]), -1, [wage-inc-2nd])
Or even:
if(missing([wage-inc-2nd]), if(missing([wage-inc-3rd]), -2, [wage-inc-3rd]), [wage-inc-2nd])
Not as clean as coalesce() but not bad either.
Regards,
Balázs
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…
.png "Filter Missing Values (Null).png")
