Increment value to a integer variable in PipeLine

gadopwbi — Fri, 16 Aug 2024 05:05:19 GMT

Hi, I've started to make a pipeline in Fabric, but I don't know how to increase the value of an integer variable using the Set Variable Activity...

The variable initially has a value of 0, then I want it to have a value of 1

any ideas ..

Thanks

Re: Increment value to a integer variable in PipeLine

frithjof_v — Sat, 17 Aug 2024 07:02:36 GMT

I think you need to use a "helper" variable to achieve this:

Because there seems to be a limitation that variables cannot be self-referencing.

So you would need to use two variables, e.g.:

counter_i

temp_j

Choose your initial value for your variable (counter_i), e.g. counter_i = 0.

Then, use these two activities to increment counter_i:

First, you set temp_j equal to counter_i.

Then, you set counter_i equal to temp_j + 1.

You can repeat these two steps multiple times in order to keep incrementing the variables.