Set variable and get variable

Set Variable is used when you want to manually set or define a value you can use later in your workflow, calculation, or application. You can create different variables based on your needs a fixed value, a value from a data column, or a value based on some condition.

Get Variable is used when you want to retrieve or use the value you set earlier.

In simple words:

• Set Variable = You store or save a value.
• Get Variable = You use that saved value later.

It gives you flexibility to work with:

• Fixed (constant) values
• Column (field) based values from datasets
• Conditional values depending on data conditions.

How to use Set and Get Variable?

Step 1: Select the “Set variable” component and join with the source.

Step 2: Open the set variable by clicking on it. The user will get three options:

Detailed View of Each Section:

Standard Variable Section

• Toggle: You can turn standard variable creation ON/OFF.
• Fields:

• • Variable Name: Name of the variable.
  • Variable Value: Constant value to be assigned.
  • Data Type: Choose datatype (String, Integer, Float, etc.).
  • Action: Option to delete the variable.

For Example:

• After selecting “Standard Variable”, click “+ Add Variable”.
• We have provided the following details:
  • Variable Name: Distributed Value
  • Variable Value: 5
  • Data Type: Integer

• Now, add the “Get Variable” component to the “Set Variable” to retrieve the standard variable we have created.

Column Variable Section

• Toggle: You can turn column variable creation ON/OFF.
• Fields:

• • Column1: Select an existing dataset column
  • Rename Column Variable: Give a friendly or customized name.
  • Data Type: Specify datatype (String, Number, etc.).
  • Action: Option to delete the variable.

For example:

• After selecting “Column Variable”, click “+ Add Variable”.
• We selected “Column1” as “Ship_Mode”, renamed it to “Shipping mode”, and set the Data Type to “String”.
• Similarly, select “Sales” for “Column1”, rename it to “Sales value”, and set the Data Type to “Integer”.

• Now, add the “Get Variable” component to the “Set Variable” to retrieve the column variable we have created.

Conditional Variable Section

• Toggle: You can turn conditional variable creation ON/OFF.
• Fields:

• • Variable Name: The New variable name you define.
  • Column Value: Source column to check the condition on.
  • Conditional Value: Variables are used to define global values within a job. If a column value fails during execution, the conditional variable’s value is saved in the specified column.
  • Data Type: Output data type.
  • Action: Option to delete the variable.Top of Form

• Now, add the “Get Variable” component to the “Set Variable” to retrieve the column variable we have created.