Tableau Course
Renaming Fields and Aliases
Renaming and aliases let you replace raw database labels and messy data values with clean, readable names — all inside Tableau, without touching the source data at all.
Two Different Labelling Problems
There are two distinct labelling issues you will encounter in real data. The first is a field name problem — the column in your source is called something like cust_id_fk or SLS_AMT_USD and you want it to say "Customer ID" or "Sales (USD)" everywhere in the workbook. This is fixed by renaming the field.
The second is a value problem — the column name is fine, but the values inside it are ugly: "E", "W", "C", "S" instead of "East", "West", "Central", "South". Or "Y" / "N" instead of "Yes" / "No". This is fixed by aliases, which apply display labels over individual field values.
↓ rename
Sales (USD)
"W" → "West"
"Y" → "Yes"
Renaming a Field — Three Methods
Tableau gives you three ways to rename a field, each useful in a different context.
The fastest method. Click once to select the field, then double-click the name text to make it editable. Type the new name and press Enter. The new name applies immediately across every worksheet in the workbook.
Right-click any field in the Data pane and select Rename. The field name becomes editable inline. Useful when double-clicking is awkward on a trackpad or when you want to confirm you are renaming the right field before editing.
On the Data Source tab, double-click any column header in the data preview grid to rename it there. This is particularly handy after a pivot — when the two new columns are still called "Pivot Field Names" and "Pivot Field Values" — because you can rename both without leaving the Data Source tab.
Resetting a Renamed Field
A rename is not permanent. Right-click the renamed field in the Data pane and select Reset Name to restore the original field name from the source. This is useful if you renamed a field by mistake or if the source name was changed and you want to re-sync.
Aliases — Renaming Field Values
Aliases work on individual Dimension values — the members inside a field, not the field name itself. Every unique value in a Dimension can be given a display alias. The alias appears in all charts, filters, tooltips, and legends. The raw underlying value is unchanged in the source data.
Edit Aliases Dialog — Mockup
Where Aliases and Renames Apply
| Change Type | Applies to | Visible in | Source data changed? |
|---|---|---|---|
| Rename field | The field name (column header) | Data pane, shelves, axis labels, tooltips, legends | No |
| Alias | Individual values inside a Dimension | Chart marks, axis tick labels, filter controls, tooltips, legends | No |
Aliases on a Pill vs in the Dialog
There is a second, faster way to alias a single value. Right-click a mark label or axis tick directly in the chart view and select Edit Alias. A small inline text box appears — type the alias and press Enter. This is handy for fixing one specific label without opening the full Aliases dialog. Note that this only works when the field is already placed on a shelf and the mark or label is visible in the view.
Renames and aliases are cosmetic — they change how things look in Tableau without changing the data. This is both their strength and their limitation. The strength: you can clean up an ugly database schema for an executive audience in minutes. The limitation: if someone else connects to the same data source without your workbook, they see the raw names and values again. For a shared team environment, the right long-term fix is to rename fields and standardise values at the source — in the database, in Tableau Prep, or in a published data source. Use renames and aliases as a quick presentation layer while you wait for the upstream fix to happen.
Practice Questions
1. How do you open the Edit Aliases dialog for a Dimension field in the Data pane?
2. Which right-click option restores a field's original source name after it has been renamed in Tableau?
3. Does renaming a field or applying aliases in Tableau modify the underlying source data?
Quiz
1. A Region field contains the values "E", "W", "C", and "S" from the database. You want the charts to show "East", "West", "Central", and "South" instead. What is the correct Tableau approach?
2. What is the fastest way to rename a field directly in the Data pane?
3. Without opening the full Aliases dialog, how can you quickly alias a single value directly from the chart view?
Next up — Lesson 18: Extracts — saving a snapshot of your data as a .hyper file for faster performance and offline access.