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 Jeremiah,
Are you using DataPrep studio or Monarch Classic ?
In DataPrep studio:
if your column type is text based you can right click on the column and choose Replace function and choose Null option which will allow to convert to any text you want including 'NULL'. If it is a number column same operation will convert blank column to 0.00
You also can create a new calculated field based on that column that has null/blank values and convert it to zeros.
If it is a text field, you can create a new formula column with the following formula:
if(isblank([blank_column]),str(1/0),'')
where [blank_column] is the field you are testing for a blank value.
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…
