Filling Empty Cells in a Field

Many reports are designed so that duplicate field values do not repeat down the page. When Monarch Classic extracts data from the report and builds a database table, it does not automatically duplicate these values, resulting in empty cells throughout the field. You can fill these empty cells with the proper field values using a setting in the Field Properties or Field List dialog.

Applying the Fill Empty Cells setting to a single field

  1. Select Input Fields from the Table Design Ribbon. The Input Field Properties Window displays.

  2. Go to the Template tab.

  3. Click Copy from previous record.

  4. Select Accept.

Applying the Fill Empty Cells setting to several fields

  1. Select Field List from the Table Design ribbon. The Field List window displays. This window displays the properties for all fields in the table, including the field types.

  2. Ensure that the Show Template Properties check box is selected. This check box is located at the lower-left corner of the Field List window.

  3. To fill empty cells using the value from the previous record, select the appropriate check box in the Fill Empty (cells) column.

  4. Repeat Step 3 to apply this setting to additional fields.

  5. Click Accept to close the Field List window and apply the changes to the table.




© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support