Creating data transformations

Rational ProjectConsole Designer Help

Data transformations are created manually and run as the startup or shutdown command of a collection task.

Rational ProjectConsole can apply some data-specific functions to collected data. Examples include calculating the logarithmic value, the area under a curve or standard deviation, aggregate data over repetitive periods, or including a lookup table that converts user names based on known quantities, such as the case where Bob Brown and Robert Brown are one and the same user.

You can use data transformations in conjunction with Perl or Basic to perform bad data handling and data cleansing techniques. Transformations also can perform simple or complex calculations and data manipulations.