Simple transformations

Tableau is not a data preparation tool. It's always better to have a clean file to start with. However, Tableau offers some simple transformation tools. When you connect to a dataset, you can, for example, use the Data Interpreter, split a column into multiple columns, or pivot your data. Let's see a case for these transformations.

For this section, I created a dataset to clean in Excel, as illustrated here:

Simple transformations


If you want to reproduce the example, you can download the Dataset to clean file from my website,, as discussed in Chapter 4: Connecting to Data and Simple Transformation section, or ...

Get Getting Started with Tableau 2019.2 - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.