Ask The Expert Session - July 14: Monarch v.2020 Excel Trapping

Rebecca_Cronin
Rebecca_Cronin
Altair Employee
edited December 2020 in Altair RapidMiner

Ask The Expert - July 14th

Working with Monarch v.2020:

Excel Trapping and other Monarch/Automator Questions

 

During this Session of 'Ask The Expert' we provided an overview of "Excel Trapping" in Monarch v.2020 as well as covered how to:

  • Change the source with an extra column in a model
  • Use "Data Pump" with current Monarch Data Prep Studio
  • Understand Function: CHR() vs VAL()
  • Understanding Credentials and Web Inputs
  • How are Excel Cells with calculations or functions in it- will it hold the value
  • Can you do Exclusion of Header vs find-replace
  • Use Multiple Row function to bring in extra lines of an address
  • Execute SQL stored procedure in Automator Script

Please find included a copy of the PPT Slide Deck along with copies of the Pre-Registered and some of the Live Questions captured during the session. 


Tagged: