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 everyone. I have a Monarch project that has information on sales per year on every country. I've been able to do some prep and I'm happy with it right now but it would be really convenient to have the information for every country on a separate excel file. Is there a way to get Monarch to create these outputs automatically?
thank you
Hi Paula,
Yes please see the attached files. This is one way you can approach the challenge;
Here are screenshots of the steps as well;
1. Export Data
2. Import Data as a CSV into Monarch Classic
3. Create a Summary
4. Export by Summary Key:
5. Run the Export :-)
Hi Paula, Yes please see the attached files. This is one way you can approach the challenge; Export Your data as a CSV from the Data Prep Studio Import that CSV into Monarch Classic Create a Summary in Monarch Classic based on the columns you need. I did have to create a 'count' column for this to work. Finally, leverage the ability to export dynamically by a Summary Key in Monarch Classic to create the unique excel file for each country. Run the Export :-) Here are screenshots of the steps as well; 1. Export Data 2. Import Data as a CSV into Monarch Classic 3. Create a Summary 4. Export by Summary Key: 5. Run the Export :-)
Thank you so much @Baba Majekodunmi, this was very helpful!
You're very welcome @Paula Rodriguez :-).
You should check out the challenges in our Altair Monarch Success Plan.
Join us for a community conversation on Pulse Width Modulation (PWM), a fundamental technique in electric motor control, and explore how different PWM strategies can yield significantly different results. This webinar provides a comparative analysis of various PWM methods and their effects on motor efficiency, torque…
Join us for a community conversation to discover the Advanced Iterative Solver(AIS) in Simcenter Feko and its application to electrically large and computationally demanding electromagnetic models. The session will provide a general overview of how iterative solution methods can help improve efficiency of large scale…
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…
