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.
I have an exported Excel file showing data by employee. I need to pull this block for each employee and get a specific value.
I searched the forums and did not see anything similiar.
How can I go about doing this?
If the data is always in the same place (row or column) then you can use the parameter in the "Read Excel" operator to specify the sheet location containing only the data you need. But sometimes that gets complicated, and the easier thing to do is simply import the entire sheet and then once the data is in RapidMiner, use Filter and Select to isolate the data you need.
If they're in tabs you might have to loop over them using the Read Excel operator and iterate over the sheet # parameter.
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…
