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 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…
