Modifying Field Names in Summaries in Data Prep Studio

When Monarch Data Prep Studio builds a summary, it assigns the row, column, and measure field names as column titles in the summary matrix. You may use these names or you may modify the column titles to provide more descriptive names.

Note that when modifying field names in a Summary display, you are, in fact, only modifying their labels. As such, the Add/Edit Summary dialog will continue to show the original names of the source fields, but the Summary display will show the updated labels.

Modifying row field names

Steps:

Select the summary with Row field names you wish to modify and then click Edit Summary.

The Edit Summary dialog displays.
Click on the Edit icon located the to left of a row field you wish to rename.

The Row Field Properties dialog displays.
Replace the name indicated in the Label field with a new field name.
Click OK to close the Field Properties dialog and then click OK on the Edit Summary dialog.

Your summary displays with the new Row field name you specified.

Modifying measure field names

Steps:

Select the summary with measure field names you wish to modify and then click Edit Summary.

The Edit Summary dialog displays.
Click on the Edit icon located the to left of a measure field you wish to rename.

The Measure Field Properties dialog displays.
Untick the box labeled Use auto-generated label.
Replace the name indicated in the Label field with a new field name.
You can modify the other properties of the measure field, namely, the display setting, number of decimal places of accuracy, and the format of the measure field. These settings are described as follows:
- In the Display field, tick the box labeled Hidden if you want the corresponding measure field hidden. A hidden measure may still be used for sorting purposes. Even though a measure column is hidden, the presence of the measure itself will generally still have some effect; for instance, blank lines and/or subtotal lines specified for a hidden measure will still produce rows in the summary. Note: Hidden columns do not get exported.
- From the drop-down available in the Decimals field, choose the number of decimal places of accuracy. Selecting a number from 0 to 9 rounds to the decimal precision specified and limits the numeric data range to 15 digits. Selecting "Floating" sets the precision to the full numeric range (i.e., ± 5.1 × 10^-324 to ± 1.7 × 10^308).
- Modify the format of the measure field (i.e., Numeric, Financial, Currency, Percent, Scientific, and Custom) from the drop-down. Tick the Use source column format if you want to apply the original column format of the measure field.
If you wish to modify the calculation applied to this measure field, enter a new calculation (e.g., any arbitrary expression involving addition, subtraction, multiplication, and division of values of numeric columns) into the Expression box.
Click OK to close the Field Properties dialog and then click OK on the Edit Summary dialog.

Your summary displays with the new Measure field name you specified.

Modifying column field names

When a row field’s values are displayed across the top of the summary matrix (i.e., when you specify Column fields), the column titles are based upon the key field values. These titles are generated dynamically each time the summary is recalculated (as it may include more or fewer key field values). Monarch Data Prep Studio does not allow you to modify the titles for Column fields, otherwise your changes would be lost when the summary is recalculated.

Modifying item field names

Steps:

Select the summary with Item field names you wish to modify and then click Edit Summary.

The Edit Summary dialog displays.
Click on the Edit icon located the to left of an item field you wish to rename.

The Item Field Properties dialog displays.
Replace the name indicated in the Label field with a new field name.
Click OK to close the Field Properties dialog and then click OK on the Edit Summary dialog.