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.
Hi Everyone,
So I created a workspace in DataPrep and uploaded it to Automator for a daily export but when Automator runs it doesn't process the filters on the Change List and gives me data I do not want. Is there a reason why Automator would be ignoring the Filter: Selected Values? In DataPrep it exports filtered properly.
Thanks,
Pat
Forgot to put versions, everything is up to date on v14.0
Patrick, can you post a screenshot of the filter dialog box?
Hi Stephen,
Below is one of the filter dialog boxes in DataPrep for a filter on by Account that has a Total row at the bottom of it that I wanted removed, so the only things selected are Totals row and exclude selected (I had to redact for privacy). The second report I actually filtered before I opened the table so it doesn't show in the Change List but it is the same as below excluding a Total row. This works fine in DataPrep including exporting from there but Automator doesn't seem to like it. Let me know if you need anything else.
Hi Stephen,Below is one of the filter dialog boxes in DataPrep for a filter on by Account that has a Total row at the bottom of it that I wanted removed, so the only things selected are Totals row and exclude selected (I had to redact for privacy). The second report I actually filtered before I opened the table so it doesn't show in the Change List but it is the same as below excluding a Total row. This works fine in DataPrep including exporting from there but Automator doesn't seem to like it. Let me know if you need anything else.Thanks,
Hmm, that seems fairly straightforward, but it's not working on the Automator for either report? The one that you filter here in the Prep Data area, and the one that you filter before loading from the Preview Data screen?
The next thing I would say to check would be the Change History in the Visual Process on Automator itself. If you click on the Workspace node, you should be able to expand the Load Plan there, and then expand the Change History for this table to make sure it matches what's on the desktop, as below:
Hmm, that seems fairly straightforward, but it's not working on the Automator for either report? The one that you filter here in the Prep Data area, and the one that you filter before loading from the Preview Data screen? The next thing I would say to check would be the Change History in the Visual Process on Automator itself. If you click on the Workspace node, you should be able to expand the Load Plan there, and then expand the Change History for this table to make sure it matches what's on the desktop, as below:
Yep looks the same and shows the Filter selected values. I haven't had the time to build a test workspace with filtering but that was my next step after I posted here.
Patrcik, I am not sure what's going on here. My suggestion at this point is that you contact the Datawatch Support team to submit a formal ticket.
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…
