Skip to main content
Version: 0.0.16

TableTransformer

Input type: Table

Output type: Table

Description​

Applies a transform on each value of a column. The input port type of the used transform has to match the type of the input column.

Example 1​

block CelsiusToFahrenheitTransformer oftype TableTransformer {
  inputColumn: 'temperature';
  outputColumn: 'temperature';
  use: CelsiusToFahrenheit;
}

Given a column "temperature" with temperature values in Celsius, it overwrites the column with computed values in Fahrenheit by using the CelsiusToFahrenheit transform. The transform itself is defined elsewhere in the model.

Example 2​

block CelsiusToFahrenheitTransformer oftype TableTransformer {
  inputColumn: 'temperatureCelsius';
  outputColumn: 'temperatureFahrenheit';
  use: CelsiusToFahrenheit;
}

Given a column "temperatureCelsius" with temperature values in Celsius, it adds a new column "temperatureFahrenheit" with computed values in Fahrenheit by using the CelsiusToFahrenheit transform. The transform itself is defined elsewhere in the model.

Properties​

inputColumn​

Type text

Description​

The name of the input column. Has to be present in the table and match with the transform's input port type.

outputColumn​

Type text

Description​

The name of the output column. Overwrites the column if it already exists, or otherwise creates a new one.

use​

Type transform

Description​

Reference to the transform that is applied to the column.