Automatically Renaming Dataset Fields

Quite often, default field names are not very human-friendly. Therefore, Arcadia Data added an option to automatically adjust field names at the level of the dataset.

Availability Note. This feature is available if Automatic Attribute Renaming is enabled.

The following steps demonstrate how to change the default column names, automatically.

  1. On the main navigation bar, click Data.

    Click DATA on main nav

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. In the left navigation menu, click samples.
  3. In the Datasets area, select World Life Expectancy (samples.world_life_expectancy).

    selecting a dataset
    Selecting Dataset 'World Life Expectancy'
  4. In the Dataset Detail menu, select Fields.

    detail of 'World Life Expectancy'
    Dataset Detail for 'World Life Expectancy'
  5. In the Fields interface, select Edit Field.

    Editing Fields of Dataset 'World Life Expectancy'
    Editing the Fields of Dataset 'World Life Expectancy'
  6. Near the top of the page, click Title Case.

    turning on title case
    Turning on Title Case for Database Fields
  7. Note that the field titles changed. For example, the Measure gdp_per_captia appears as GDP Per Capita.

    The Title Case option does not affect fields that are calculated over table fields, such as gdp.

  8. Click Save.

  9. [Optional] Open an existing visual on this dataset, and note the change in the appearance of the following objects:

    1. Dimensions and Measures in the Fields menu
    2. The fields on the shelves
    3. The axes labels
    4. The field labels in the Tooltip.
    5. [In lower image only] The calculated fields remain unchanged by the title case option.
    proving how title case change propagates
    Effect of Title Case on Visuals