© Tim Costello, Lori Blackshear 2020
T. Costello, L. BlackshearPrepare Your Data for Tableauhttps://doi.org/10.1007/978-1-4842-5497-4_8

8. Group and Replace

Tim Costello1  and Lori Blackshear2
Euless, TX, USA
Fort Worth, TX, USA

Group and Replace is, in my opinion, one of Preps’ most powerful tools. With it you can clean up some very bad data very quickly. I’ve been working with data for almost 20 years, and I’ve never seen anything quite like it in a tool like this.

To start this chapter off, let’s open a new connection to the dirtyData file we worked through in the last chapter. I’ll leave that to you; if you have trouble, you can refer to Chapter 3 for a refresher on connecting to data.

We will begin by adding a generic step just like we did ...

Get Prepare Your Data for Tableau: A Practical Guide to the Tableau Data Prep Tool now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.