Through exploration, data quality issues often come to the surface. You must triage them and, in many cases, correct, clean, or change data in some way. The interactive Transform area in Studio helps you turn your data into data that is fit for advanced analysis.
Transform helps you isolate data quality problems and lets you quickly apply a number of data transformations to clean or restructure the data.
You can find Transform in Studio here:
Because data transformation and data exploration are two integral aspects of any discovery project, you can seamlessly transition between Transform and Explore within a unified interface, which promotes a smooth workflow.
Here is an example of what Transform looks like in a project:
In this image, you can see the Transform area of Studio. Notice the drop-down attribute menu in the second column. It includes options to hide an attribute, mark it as favorite, edit it, and sort it. To the right, you can also see the Transform Script panel, with three transforms created by the project's user.
Also notice the transform menu just under the header. The Transform menu is made up of the tabs: Basic, Convert, Advanced, Shaping, and Editor.
The transforms that display under each tab vary depending on the data type of the attribute you select. For example, if you select a date time attribute, the Basic tab displays the Truncate date and Extract date part transforms. These are both transforms that are contextually appropriate for date time attributes. And if you select a numeric attribute, the Basic tab displays the Absolute value transform because the Absolute value transform is contextually appropriate for numeric attributes.
After you run the transform script by clicking Commit to Project, the data is transformed and ready for further analysis.