Skip to content

Files

Latest commit

7b7434b · Dec 6, 2021

History

History
47 lines (36 loc) · 2.56 KB

control-flow-append-variable-activity.md

File metadata and controls

47 lines (36 loc) · 2.56 KB
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

Append Variable activity in Azure Data Factory and Synapse Analytics

[!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.

Create an Append Variable activity with UI

To use a Append Variable activity in a pipeline, complete the following steps:

  1. 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.":::

  2. Search for Append Variable in the pipeline Activities pane, and drag an Append Variable activity to the pipeline canvas.

  3. Select the Append Variable activity on the canvas if it is not already selected, and its Variables tab, to edit its details.

  4. Select the variable for the Name property.

  5. 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.":::

Type properties

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

Next steps

Learn about a related control flow activity: