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:

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

   The Edit Summary dialog displays.

2. Click on the Edit icon located the to left of a row field you wish to rename.  

   

 

The Row Field Properties dialog displays.



 

3. Replace the name indicated in the Label field with a new field name.

4. 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:

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

   The Edit Summary dialog displays.

2. Click on the Edit icon located the to left of a measure field you wish to rename.  

   The Measure Field Properties dialog displays.

   

    

3. Untick the box labeled Use auto-generated label.

4. Replace the name indicated in the Label field with a new field name.

5. 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.

6. 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:

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

   The Edit Summary dialog displays.

2. Click on the Edit icon located the to left of an item field you wish to rename.  

   The Item Field Properties dialog displays.

3. Replace the name indicated in the Label field with a new field name.

4. Click OK to close the Field Properties dialog and then click OK on the Edit Summary dialog.