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.
I am trying to read from 2 access table. Is there a function that states if id is found in table 1 , Append and add a new column in Table 2 (the main customer table), else not found set to No in table 2?
Not sure if I completely understand your request, but one way to check if an id is in one table but not in the other would be to use the 'Set minus' operator. You will then have a set with records that are not in your table, so you can use that outcome to append them.
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…
Join us for a community conversation to explore how different modeling approaches in Simcenter PSIM can help engineers simulate power electronics systems while balancing accuracy, simulation speed, and design insight. What you'll learn: Power transistor modeling : Thermal and high fidelity models Protection component…