Set variable

Question

Hi friends I am very confusing using set variable I need good example practical to understand help please I already read documents but still not clear

Answer 1

Hi @Anshal ,

In addition to what @Nandan Hegde mentioned, some of the use cases that I know are below.

1. Declare and Initialise a string or Boolean variable with true and use it in an until loop and based on some condition, update it to false and terminate the loop based on that variable value. Reference
2. Assigning an activity output or activity error message and writing it to a file or database table.
3. Write an expression like formatdatetime(utcnow(),'yyyy-MM-dd') and assign it to a variable and use it in any number of activities to avoid repeating same expression.

Will add more use cases as and when I recollect.

Thanks.

Answer 2

Intro:https://learn.microsoft.com/en-us/azure/data-factory/control-flow-set-variable-activity

video:
https://www.youtube.com/watch?v=rzDZdRifC40

use case:
https://azurede.com/2021/09/25/azure-data-factory-increment-variable-using-set-variable-activity/