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.
Current filter is based on a date but its too much data. I'd like the filter to only gather the last 90 days. I tried using the function but I keep getting an error. Looking for an example to base my filter on.
What formula are you trying?
Try something similar to:Today()-90 > [Formula Column]
Where [Formula Column] is the name of the column you are using to compare to today's date.
Hi Michael,
Databases
It depends on where you data is coming from. For example, if you data is coming in from a database like SQL, you do have some options to apply filtering before importing it into Monarch in Monarch Classic.
Here's a recording on how to import data from SQL in both Data Prep Studio and Monarch Classic.
How to Import Data into SQL
Flat Files
If you're importing from a Flat file, such as a report, or csv, or excel file then you can use Chris's formula example is a good place to start, but there might be more options depending upon the data source and other options to bring it into Monarch.
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…
