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%

You can assign a pipeline variable a value comprised of a global variable and a pipeline variable. For more information, see Assigning String Variables and Global Variables to the Same Pipeline Variable.