The most recent content from our members.
There's a wealth of content waiting for you to explore! Need support or have a question? Sign in or register to get started.
I need to find a way to group or aggregate transaction amounts done on Saturday, and Sunday (or on a holiday) to show their total on the next business day, usually Monday. I have a list of transactions by account number and I need to aggregate the transaction totals for each business day, grouping them by date seems easy…
Good afternoon all, We have a requirement to create a Monarch project where the summary should be different than the usual one when creating our posting files for SAP. In this case, we have an original database (excel) where the key value are provided in column A. These key values can be shown as consecutive way or in very…
Exercise Info Application (Classic vs Data Prep Studio): Data Prep Studio Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate/Advanced Skills/Features Tested: PDF Expert Mode Systems of Record: N/A Estimated Time to Solve: 10 mins Exercise files required are attached Below; Inventory Report_M.pdf Exercise…
I have a worksheet with transactions neatly organized. But the first four lines of the sheet have information which is not deemed needed except for the account number which is the last nine characters of cell A2. How can I extract/append that number to the last column of the sheet?
We are pleased to share that Altair have been recognized as Leaders for the 2nd year in a row in the Gartner(r) Magic Quadrant(tm) for Data Science and Machine Learning Platforms! In the words of Altair CTO Sam Mahalingham: 'We think being recognized as a Leader for the second consecutive year further validates Altair’s…
Description: Wanted to know why that some rows of the change history allow itself to be edited but some other rows cannot be. Also wonder if the edit button is the only way to modify an existing change without having to roll all the way back to the row I want to modify. Product/Topic Name : Monarch Data Prep Studio *Note…
The Community Team would like to introduce the April Champion of the Month, Lasse Kaikko @Lasse. Lasse works as a Solution Manager in a team where one of the team’s key responsibilities is to automate processes of transforming unstructured or semi-structured data into a structured format. He has been working with data…
Hi, I'm trying to change the formatting of a numeric field but I can't select the OK button. This happens regardless of which format I choose. Any ideas what might be causing this? Thanks! -Lasse
Exercise Info * Application (Classic vs Data Prep Studio): Classic * Level of Difficulty (Beginner, Intermediate, Advanced): Intermediate * Skills/Features Tested: Report Trapping, Filters, Calculated Fields, Summary * Systems of Record: Not Applicable * Estimated Time to Solve: 15 mins * Exercise files required are…
This video provides an overview of how to run a Data Prep Studio Visual Process.
Ask The Expert Series on May 25, 2021 (Monarch & Automator) The Session began with a brief overview of opening MS-Excel & MS-Access data sources/files followed with how to bring in data using ODBC, OLEDB, & SQL Server connections before diving into the LIVE Questions. Monarch Question: * Explained the differences of 32-bit…
Overview: Short pdf with a collection of information, exercises and tools to bring you up and running especially - but not only - as experienced user of the classic HyperMesh interface: Slide #2: Finding your Tools and Functionality Slide #3: Getting Started through Youtube exercises Slide #4: Further Sources of Information
Hi Everyone, We have some exciting sessions lined up for August and the rest of the year. New sessions are also added to the exciting Power Conversion and Magnetic Chat series. Register Now! Summary of our Upcoming Events: MotionView/MotionSolve 2025.1 for Vehicle Dynamics [ August 27] - Learn about the latest advancements…
🚀 Altair RISE Program We're excited to launch an exclusive 6-month program designed to recognize and reward our most engaged community members! Whether you're answering questions, sharing solutions, or participating in discussions, RISE gives you recognition in the community while helping you grow your expertise. Progress…
The Community Team would like to introduce the August Champion of the Month, Dr. R. B. B. Ovando. Dr. Ovando is a researcher and engineer working at the intersection of electromagnetism, heat transfer, fluid dynamics, materials (stress, mechanical and physical metallurgy), and numerical simulation. His work combines finite…
Hi Everyone, Sorry for the delay on our August roundup! Its been a busy month, but we didn't want to miss highlighting all the great activity in our community. 📢Introducing the Altair RISE Program Get ready for something special! Our RISE Program(Recognition for Innovation, Solutions & Expertise) officially launched in…
