19 Transforming Project Data Sets

This section describes how to correct and enrich data sets within a project.

• Overview of transforming an attribute
  All transforms follow the same basic work flow.
• Transform page controls
  There are a number of general controls on the Transform page to toggle the data grid, filter and sort, and display whitespace in attribute values.
• Basic transform operations
  Simple transforms such as splitting attributes, trimming attributes, or changing the case of attributes are listed on the Basic tab of the Transform page.
• Conversion transform operations
  Conversion transforms convert the data type of an attribute that you select to another data type. They are listed on the Convert tab of the Transform page.
• Advanced transform operations
  More advanced transforms such as creating geo heirarchy attributes, extracting entities or phrases, managing null values and so on are listed on the Advanced tab of the Transform page.
• Shaping transform operations
  Shaping transforms are listed on the Shaping tab of the Transform page.
• Creating custom transformations
  If the default transforms do not meet your needs, you can also create and add custom transformations to a transformation script on the Editor tab of the Transform page.
• Managing and executing the transformation script
  The transformation script tracks and executes the transformations.
• Creating a new data set from the transformed data
  After running a transformation script, you can create a new data set in the Catalog based on the transformed project data.
• Sharing a transform script
  The ability to publish and share scripts provides a useful starting point for other projects to build a transform script.
• Tips for better performance
  There are some simple things you can do while designing a transform script to improve its overall performance.