Prepping data

Tableau Prep comes with different prepping steps. We will divide them in four subcategories: cleaning, joins and unions, aggregating, and pivoting.

Cleaning data

The following canvas we have seen before in The Tableau Prep GUI section. The user can simply click on + next to the input and select Add Step, which will create the cleaning step. During the cleaning step, multiple things can be done, such as filtering and creating a calculated field:

1. Once a value is selected, you have the options to keep it, exclude it, edit it, or replace it with Null:

2. Another slightly hidden option is to click on the ellipses (...) next to the column header and select Clean.

The following is the screenshot:

This clean functionality...