...
Description
This step allows you to get the value of a variable. This step can return rows or add values to input rows.
Note: You must specify the complete variable specification in the format ${variable}
or %%variable%% (as described in Variables) . That means you can also enter complete strings in the variable column, not just a variable.
For example, you can specify: ${java.io.tmpdir}/kettle/tempfile.txt
...
and
...
it
...
will
...
be
...
expanded
...
to
...
/tmp/kettle/tempfile.txt
...
on
...
Unix-like
...
systems.
...
See
...
also
...
the
...
...
...
step.
...
To
...
convert
...
the
...
Variable
...
into
...
a
...
data
...
type
...
other
...
than
...
String
...
use
...
Select
...
Values
...
-
...
Meta
...
Data
...
tab.
...
To
...
get
...
system
...
values,
...
including
...
command
...
line
...
arguments,
...
use
...
the
...
Get
...
System
...
Info
...
step.
...
Options
Option | Definition |
---|---|
Step name | The name of this step as it appears in the transformation 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}/kettle/tempfile.txt |
...
and |
...
it |
...
will |
...
be |
...
expanded |
...
to |
...
/tmp/kettle/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. |
Trim type | Type trim this field before processing: select either none, left, right, or both (left and right). |