Renaming columns
When it comes to cleaning data, one of the simplest yet most powerful actions might be simply renaming your fields to a more user-friendly format.
Tableau Prep steps can be categorized into three items: inputs, transformations, and outputs. During the first two, the input and transformation steps, we'll always have the ability to change any field name as desired.
Getting ready
To follow along with this recipe, download the Sample Files 3.1 folder from this book's GitHub repository.
How to do it…
Open up Tableau Prep Builder and connect to the December 2016 Sales.xlsx file:
- Drag the Sales_Data sheet onto the flow canvas:
Figure 3.1 – Connecting to Sales_Data
When you select the Sales_Data input step, the bottom pane will show a preview of all the fields in the source data, along with their data type and some sample values:
Figure 3.2 – These field names are not user-friendly
- In order to change any of the field...
