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 all,
How can I extract details from the date format?
For example,
If I have the date as JAN 1 2017
I would like to generate 3 attributes like this
month Date Year
Jan 1 2017
Thanks in advance.
Best,
Raj.
Hi,
RapidMiner has multiple ways to get your solution.
I suggest using Generate Attributes but instead of date_get you could use date_str_custom which converts your date to a string.
I would recommend this solution because it allows you to format the desired output in the way you want (e.g. language / abbreviations [Mon vs. Monday] / ...). This way you are also able to extract the weekday of this day!
A help on the parameters / variables representing which portion of the date can be found in the Help of the Operator "Nominal to Date".
Edin
I would convert those to Nominal values first and then use the Split operator.
I would go for date_get in GenerateAttributes.
Martin
Another option would be to use Date to Numerical, which allows you to extract any portion of the date relative to most other portions (e.g., day of the week, day of the month, month of the year, etc.) but the resulting data is numerical rather than nominal in format. But you could then use Map to convert to whatever nominal values you want.
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…
