title | titleSuffix | description | ms.service | ms.subservice | ms.custom | ms.topic | author | ms.author | ms.reviewer | ms.date |
---|---|---|---|---|---|---|---|---|---|---|
Append Variable Activity |
Azure Data Factory & Azure Synapse |
Learn how to set the Append Variable activity to add a value to an existing array variable defined in a Data Factory or Synapse Analytics pipeline. |
data-factory |
orchestration |
synapse |
conceptual |
chez-charlie |
chez |
jburchel |
09/09/2021 |
[!INCLUDEappliesto-adf-asa-md] Use the Append Variable activity to add a value to an existing array variable defined in a Data Factory or Synapse Analytics pipeline.
To use a Append Variable activity in a pipeline, complete the following steps:
-
Select the background of the pipeline canvas and use the Variables tab to add an array type variable:
:::image type="content" source="media/control-flow-activities-common/add-pipeline-array-variable.png" alt-text="Shows an empty pipeline canvas with the Variables tab selected having an array type variable named TestVariable.":::
-
Search for Append Variable in the pipeline Activities pane, and drag an Append Variable activity to the pipeline canvas.
-
Select the Append Variable activity on the canvas if it is not already selected, and its Variables tab, to edit its details.
-
Select the variable for the Name property.
-
Enter an expression for the value, which will be appended to the array in the variable. This can be a literal string expression, or any combination of dynamic expressions, functions, system variables, or outputs from other activities.
:::image type="content" source="media/control-flow-append-variable-activity/append-variable.png" alt-text="Shows the UI for an Append Variable activity.":::
Property | Description | Required |
---|---|---|
Name | Name of the activity in pipeline | Yes |
Description | Text describing what the activity does | No |
Type | Activity Type is AppendVariable | Yes |
Value | String literal or expression object value used to append into specified variable | Yes |
VariableName | Name of the variable that will be modified by activity, the variable must be of type ‘Array’ | Yes |
Learn about a related control flow activity: