Assigning String Variables to Pipeline Variables
In addition to assigning a literal value to a variable, you can assign the value of another String variable to a pipeline variable of type String, String List, or String Table. You might do this if you wanted to derive the default value from a variable that exists in the pipeline at run time.
To specify a String variable as the value for a pipeline variable, you enclose the name of the String variable in % symbols (for example, %Phone%) and then select the Perform pipeline variable substitution check box.
Keep the following information in mind when using pipeline variable substitution:
You can use String variables to specify values for pipeline variables of type String, String List, and String Table only.
You must select the
Perform pipeline variable substitution check box for the variable substitution to occur.
You can mix literal values with String variables. For example, if you specify
(%areaCode%) %Phone%, the resulting String would be formatted to include the parentheses and space. If you specify
%firstName% %initial%. %lastName%, the period and spacing would be included in the value.
If the variable name that you specify between % does not exist in the pipeline at run time, no variable substitution occurs. Instead, the value of the pipeline variable will be
%StringVariableName%. If you specify
%lastName% as the value for the
familyName variable, and the
lastName variable does not exist in the pipeline at run time, the
familyName variable value is:
%lastName%