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,
I'm currently working in a file that will need multiple 'Nominal to Date' operators for multiple columns. Is there an operator that I would be able use to do all of the conversions or would I need to use an opeartor per column(field)?
TIA
@mtran how are you loading the data? If you're doing it via a flat file like CSV or XLS, you can set the attribute column as a date-time format on load. If not, you could try a 'Guess Types' operator but I'm not sure if that will work.
@Thomas_Ott Thanks for the quick reply. I noticed I was able to set the data types to 'Date' when using flat files but one of the guys on my team is pulling data in from SQL server.
You can use the Loop Attributes operator to loop through each date field and use nominal-to-date in one hit.
(Remember to check reuse results) - if using Macros for the attributes then this process can be really easily reused.
I'm sure I recall seeing @awchisholm using a bit of Groovy script for this type of conversion before as well.
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…
