DATA CLEANING AND FORMATTING
Having investigated the structure of the data and removed any unnecessary fields, you can now shift your attention to the individual fields that require cleaning and formatting. You do that by adding another step to the flow.
Cleaning Steps and the Profile Pane
In order to remedy the issues that you noticed with the Orders_Central data, you will add a cleaning step.
In the Flow pane, choose the input step Orders_Central, click the plus symbol, and choose Add Step, as shown in Figure 10.10.
Figure 10.10 Adding a cleaning step to a flow.
When you add such a step, the workspace changes, and you now see a detailed view into the rows of the data (see Figure 10.11).
Figure 10.11 Workspace with the Profile pane.
The Profile pane opens below the Flow pane. It consists of three parts. At the top is a grey toolbar; the icons on it change depending on the selections. Beneath that are the Profile cards. These show you the field headers as well as lists of the different...
