Defining a Transformation

You can define data transformations to be applied during either the log processing or transformation phase of dataset construction.

The following transformations work only when defined in the Transformation.cfg file or in a Transformation Dataset Include file:

• AppendURII
• CrossRows
• LookupRows
• ODBC Data Sources
• Sessionize

To define a transformation

1. Use the Profile Manager to open the dataset configuration file in which you want to define the transformation.

   • (Recommended) To open a dataset include file, see Dataset Include Files.

   • To open the Log Processing.cfg file, see Editing the Log Processing Configuration File.

   • To open the Transformation.cfg file, see Editing the Transformation Configuration File.

2. Right-click Transformations, then click Add new > < Transformation type>.

3. Input the appropriate information for your transformation. For descriptions of the transformation types and information about their parameters, see the following sections:

   • Standard Transformations
   • URI Transformations
   • Integrating Lookup Data

4. After you have defined your transformation(s) in the configuration file, save the file locally and save it to your dataset profile on the data workbench server.

   Tips for defining and editing transformations:
   

   • When editing the configuration of a transformation within a data workbench window, you can use shortcut keys for basic editing features, including cut (Ctrl+x ), copy (Ctrl+c) , paste (Ctrl+v ), undo (Ctrl+z ), redo (Ctrl+Shift+z ), select section (click+drag), and select all (Ctrl+a ). In addition, you can use the shortcuts to copy and paste text or entire transformation definitions from one configuration file ( .cfg) to another.

   • For any transformation that you define, you can add one or more comment lines to the Comments parameter to further describe the transformation or add notes about its use. To add a comment using data workbench, right-click the Comments label, then click Add new > Comment Line.

   • You can open the configuration of any transformation from a Transformation Dependency Map. After you open the configuration, you can edit it and save your changes. For information about Transformation Dependency Maps, see Dataset Configuration Tools.

   • An empty string output from a transformation can overwrite a non-empty string in the output field.