Tableau Prep comes with different prepping steps. We will divide them in four subcategories: cleaning, joins and unions, aggregating, and pivoting.
Prepping data
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:

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

- 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...