Data Analytics - Ask The Expert Recurring Series Monarch & Monarch Server(Automator) focus. April 26, 2022 Session reviewed Floating Traps in Monarch Complete v.2021 before going into LIVE Q/A.

Rebecca_Cronin
Rebecca_Cronin
Altair Employee
edited May 2022 in Altair RapidMiner

Ask The Expert Series on April 26, 2022 
Monarch & Monarch Server(Automator)



The Session began with a brief overview of Floating Traps in Monarch Complete v.2021 before diving into the LIVE Questions. 


The Session began with our Expert reviewing the following:

  • Session began with Mo providing overview of the Monarch "Trapping" technique to identify certain lines within a Report(s) per Trapping Rules(instructions). {Covered within approximately the first 30-mins of the Session}  
    • Touched on Trapping Rules
    • Templates
    • Character Types
  • Reviewed Standard Trap
  • Reviewed Floating Trap - in how the data shifts around.
    • The KEY is to locate the consistent pattern to create the trapping pattern(rules)

LIVE Questions submitted:

Monarch:
1.  I have built a data prep workspace blending 2 files hoping to generate a properly formatted SDF file.  When I build the workspace into a visual process in Automator and then build out the export, I can get the export to export the file in SDF format but I always loose the column size formats, it has to be space delimited and each column has to be a particular length when the resulting SDF file is generated.  Can the experts provide any advice on how to resolve this?

  • Mo reviewed & demonstrated how to correct this experience.  Will create a separate Post/KB to include the steps to resolve the above. 

2. Do floating traps work when the report is complex with the trap moving within a multiple line inspection?  

  • Unfortunately, not.  Standard and Floating traps can only be applied to a single line.  It may be possible using RegEx trapping, but the order and consistency of the CR/LF would be important.


3.  The sub-functionality that Mo spoke to after selecting fields when trap on Line 1 is?

  • If referring to splitting the last line into City, State, Zip?  One will utilize the split function available by right clicking in the prepare window.  There is a specific function for City, State, Zip and several other generic functions.

 
4.  Another issue also cropped up, we need a “CR” or carriage return that marks the end of the file and it’s format is a row of “9999”, do the experts have any idea how to end a file with a single row of all 99999999’s?   That is what I meant, 99999999999s that are the CR – Sounds like a total of 510 ‘9’ – basically the width of the file ?

  • Ran out of time to review within the session.  Will create a separate Post/KB to include the steps to resolve the above. 

 


Additional Resources:

Using the Floating Trap - DPS     Using the Floating Trap- Classic      Split Address into Parts- DPS

  


Tagged:

Categories