Show Menu
TOPICS×

Sample Data Workbench Transform.cfg Files

Information about how to specify parameters in the Transform.cfg file based on the several scenarios.
In each sample, the file is displayed as a Transform.cfg window in data workbench.

A Simple Data Workbench Transform.cfg File

The following Transform.cfg window provides instructions to read .vsl files from the Logs directory and export the x-timestring and x-trackingid fields to a text file stored in the Logs\VT directory. Because no file rotation period or output file name format is specified, each file contains data for one calendar day and has a name in the default format %yyyy%%mm%%dd%-%x-mask%.txt.

Output with Comma-Separated Values

The following Transform.cfg window provides instructions to read .vsl files from the Logs directory and export fields 0 through 13 to a comma-delimited ( .csv) file stored in the Logs\VT\CSV directory. Because no file rotation period is specified, each file contains data for one calendar day. The output files are .csv files named in the format %yyyy%%mm%%dd%-%x-mask%.csv.

Sample Log Files

You can configure transformation functionality to create and maintain an up-to-date, compact version of your full log files. Doing so enables you to test your dataset configurations quickly, with reprocessing times of seconds or minutes instead of hours needed to reprocess the entire dataset. The following example provides an example of how to configure transformation functionality to do this.
The following Transform.cfg window provides instructions to read .vsl files from the Logs directory and export the x-timestring and x-trackingid fields to a text file stored in the Logs\VT directory. The specified Hash Threshold filters certain tracking IDs from the dataset, thereby creating a dataset that is sampled by a factor of 100. Because no file rotation period is specified, each file contains data for one calendar day. The names of the output files are in the default format %yyyy%%mm%%dd%-%x-mask%.txt.

Splitting Log Files by Web Site Section

The following Transform.cfg window provides instructions to read .vslfiles from the Logs directory and export the x-timestring and x-trackingid fields to a text file stored in the Logs\VT directory. The regular expression transformation ( RETransform) takes as its input the cs-uri-stem field and creates a new field (x-site) that defines a section of the site. The x-site field is included in the name of output text files, each of which contain data for one calendar day.