-
How can I aggregate or group monetary transactions on the next business day
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…
-
Altair Monarch - Summary respecting line position of original database
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#42: Inventory Report Analysis
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…
-
Data Prep - Excel Worksheet Design - Append last nine characters of a long line and append
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?
-
Altair is a 2X Leader in the 2025 Gartner® Magic Quadrant™ for Data Science and Machine Learning
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…
-
Monarch Data Prep Studio - Change History - Edit this column change Inquiry
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…
-
Community Champion of the Month - April, 2025
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…
-
Issue with formatting numeric field / DPS 2024.1
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
-
Altair Monarch Exercise 5 - Homes Analysis
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…
-
Monarch Server Essentials Training 18 of 20 - Running a Data Prep Studio Visual Process
This video provides an overview of how to run a Data Prep Studio Visual Process.
-
Ask The Expert Recurring Series on May 25, 2021 (Monarch & Automator)
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…
