You can define data transformations to be applied during either the log processing or transformation phase of dataset construction.
Adobe recommends defining transformations in either Log Processing or Transformation Dataset Include files instead of in Log Processing.cfg or Transformation.cfg.
The following transformations work only when defined in the Transformation.cfg file or in a Transformation Dataset Include file:
To define a transformation
Use the Profile Manager to open the dataset configuration file in which you want to define the transformation.
Right-click Transformations, then click Add new > < Transformation type>.
Input the appropriate information for your transformation. For descriptions of the transformation types and information about their parameters, see the following sections:
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.