transform Name

The name of this transform as it appears in the pipeline workspace.

Name

Name of the field.

Variable

Allows you to enter variables as complete strings to return rows or add values to input rows. For example, you can specify: ${java.io.tmpdir}/hop/tempfile.txt and it will be expanded to /tmp/hop/tempfile.txt on Unix-like systems.

Type

Specifies the field type: String, Date, Number, Boolean, Integer, BigNumber, Serializable, or Binary.

Format

Allows you to specify the format of the field after the type has been determined.

Length

For Number: Total number of significant figures in a number; For String: total length of string; For Date: length of printed output of the string (for example, entering 4 would only return the year).

Precision

For Number: Number of floating point digits. Not used for String, Date, or Boolean.

Currency

Used to interpret numbers with currency symbols. For example, $10,000.00 or E5.000,00.

Decimal

Used to indicate whether to use a period (“.”) or comma (“,”) for number values.

Group

Used to indicate whether to use a period (“.”) or comma (“,”) for number values.

TrimType

Type trim this field before processing: select either none, left, right, or both (left and right).