Monarch 2020 Features
The list below highlights new features in the Monarch version indicated.
Monarch 2020.1
Monarch Classic Highlights:
-
Localization for French and German
-
Monarch Utility – Redact sample lines from Models and Workspaces
-
Monarch Utility – Clear credentials from Workspaces, Projects, and Models
-
YearFrac Function
-
Various bug fixes
-
Various UI/UX improvements
Data Prep Studio Highlights:
-
Localization for French and German
-
YearFrac function
-
Various bug fixes
-
Various UX/UI improvements
Monarch 2020.0
Monarch Classic Highlights:
-
Support for passwords of any length
-
Support for password-protected Excel inputs
-
Support for Excel XLSB inputs
-
Support for scientific notation in the Expression Editor
-
Monarch Utility: Ability to perform XMOD to DMOD conversion via the command line
-
PDF input engine enhancements, including Snap Left and Snap Up to improve alignment for certain files
-
Various bug fixes
-
Various UI/UX improvements
Data Prep Studio Highlights:
-
Ability to specify column types in load options for delimited text
-
Editing of cleared credentials for tables saved in workspaces
-
Fixing of problematic transforms and appends
-
Support for passwords measuring a maximum length of 128 characters
-
Worksheet Design - "Excel Trapping" for extracting data from complex, hierarchical Excel Worksheets
-
Export/import tables to/from workspaces
-
New functions: Remove Alpha Characters, Insert Text, Max Split Count for Left/Right Split
-
PDF input engine enhancements, including Snap Left and Snap Up to improve alignment for certain files
-
Support for password-protected Excel (.xlsx) file imports via Worksheet Design and the native Monarch Excel Table connector
-
Support for hosted HyperWorks Units and HyperworksEDU
-
Enhanced column list
-
Save workspaces without file data
-
New Map Columns dialog to try and accommodate schema changes in underlying data sources
-
New metadata column for worksheet names from Excel files
-
Enhanced security options for passwords and other sensitive connection string parameters
-
Dynamic sheet name/location support
-
Various UX improvements
NOTES:
-
If you have a license for Monarch Complete, you will have access to both Classic and Data Prep Studio features.
-
If you have a license for Monarch Classic, you will have access to Classic features only.
Contact Altair Sales if you would like to upgrade your license to gain access to all of the features listed above and more.
Related links


