7. Self-Referencing Variable is not allowed
In this video we learnt that In a Set variable activity, you can't reference the variable being set in the value field, that is, no self-referencing.
To work around this limitation, set a temporary variable and then create a second Set variable activity. The second Set variable activity sets the value of the iterator to the temporary variable.
#datafactory #azuresynapse #dataengineer #azuresynapseanalytics #adf #microsoft #dataengineering