From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Removing and renaming fields - Tableau Tutorial
From the course: Cleaning, Transforming and Prepping Your Data With Tableau Prep
Removing and renaming fields
- [Instructor] Often, to make it easier to do our analysis, we want to rename the fields to make them something more meaningful. Luckily we don't have to stick with the default values that come across from our data set. You can rename any of the fields in Prep, and these will persist to the rest of the analysis. Now common use case for this is where you've used an automatic split. So for example, we have our customer ID here that consists of two parts. Now if I use the automatic split, we're going to get two new columns. Now by default, it calls them Customer ID Split One, Customer ID Split Two. That doesn't really mean anything to anybody. In actual fact, I know from this customer ID that the first part are the customer initials. So I'm going to rename that. So to do that, I can either click on the drop down and click on rename field, and I can change to Customer Initials. And it has now renamed that field, and if we look at the bottom, in the data grid, we can now see it's called…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Splitting fields into new ones3m 34s
-
(Locked)
Removing and renaming fields2m 40s
-
(Locked)
Cleaning data using calculated fields3m 33s
-
(Locked)
Filtering data3m 48s
-
(Locked)
Grouping values3m 48s
-
(Locked)
Replacing values3m 49s
-
(Locked)
Keeping track of changes4m 23s
-
(Locked)
Challenge 3: Cleaning data33s
-
(Locked)
Solution 3: Cleaning data2m 43s
-
(Locked)
-
-
-
-
-
-