Automatically renaming dataset fields

Quite often, the column names of the base data tables are not very human-friendly. CDP Data Visualization gives you the option to automatically adjust field names at the level of the dataset.

The following steps demonstrate how to prevent data fields from appearing in visualizations and applications of dataset World Life Expectancy [data source samples.world_life_expectancy]. The fields comments, lat, and lng are empty, so they are good candidates for this operation.

  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).
  4. In the Dataset Detail menu, select Fields.
  5. In the Fields interface, select Edit Field.
  6. Near the top of the page, click Title Case.
    turning on title case

    The field titles change. 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.

    title case turned on
  7. Click Save.
  8. [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