Monarch Solutions to Problem Data

Seven Solutions to Problem Data

1. Templates – the most essential tool
2. Multi-line Sample – used when records are consistent and more than one line
3. Clear Field Values – used when records contain a variable number of lines, i.e. intermittent fields (V10)
4. Advanced Field Properties – for multi-line/variable fields, i.e. wrapping fields
5. Address Block Wizard – a table feature to split addresses info fields
6. Multi-Column Regions – used when detail wraps like a newspaper
7. Floating Trap – used for floating fields
8. “Insiders Only” Quick Tip

There are infinite variations of source data – probably as many report layouts as people creating them. Monarch has a vast assortment of tools and solutions to handle these problems so you are not limited to the ones presented here. Many problems will have more than one possible solution. Solutions can be applied in combination and in surprising ways. Be creative. The solutions presented here could be starting points for your own exploration.

PROBLEM	SOLUTION
Values in the table are mismatched to the wrong records.	Make sure you are applying the templates correctly; perhaps an append should be a footer.
Your report records are multiple lines (consistent)	Multi-line sample
Your report records contain multiple, variable lines with intermittent fields.	Clear Field Values a.k.a. Cleared by (V10)
Your report contains fields that wrap and vary in length. (e.g.comment, remark, block address)	Advanced Field Properties
Your report contains addresses that wrap into blocks and vary in length.	Address Block Wizard (after using Advanced Field Properties)
Your report records wrap like newspaper columns.	Multi-column region (MCR)
A field (or fields) in your report “float”.	Floating Trap

   
   
    Search Datawatch Corporation and Monarch Resource websites!

   
   

Videos and product description copyright by Datawatch Corporation
Copyrights, logos and trademarks are properties of their respective owners.
Monarch, Monarch Pro and Datawatch are trademarks of Datawatch Corporation.