Profiling, cleaning, and grouping data

In this section, we are going to begin the process of profiling, cleaning, and grouping data in Tableau Prep Builder. Of all the functions in Prep Builder, the clean step is the one we will use most often. In fact, it is recommended to add a clean step after any other type of step to see if the previous step transformed the data in the manner we were expecting.

Let’s pick up where we left off in the previous section:

1. The top right-hand section of the Tableau Prep Builder user interface is the flow pane. It gets this name because it is the area where we get a graphical representation of how our data flows through the preparation process. Continuing from the previous section, your flow pane should look like Figure 3.9:

Figure 3.9 – The flow pane

2. To create a clean step, click on the + symbol to the right of the box. When the drop-down menu appears, select Clean Step, as shown in Figure...