Within a loop, how can i count number of rows in each iteration and have a cumulative total?

[taylorpeter55]

Hi all,
I have a workflow that checks user access in SAP. To do this I have a loop that loops around a list of users roles and collects whether each roles provides access to a list of predefined tables.

Currently, I am downloading table access for all roles within a loop and then filtering on those which provide table access. However, I want to improve performance by exiting a loop once all of the required tables have been granted by a combination of the roles. (i.e. if the first 2 roles grant access to all 4 tables, there is no need to check whether the remaining 5 roles also provide access).

What I am trying to achieve is the following:

To run a workflow, a user requires access to 4 different tables.

Iteration 1 - Role 1 provides access to 3 of the required tables.

Cumulative total = 3

Iteration 2 - Role 2 provides no access to the required tables.

Cumulative total = 3

Iteration 3 - Role 4 provides access to 1 of the required tables.

Cumulative total = 4.

At this point, I want the loop to end because the required number of tables equals the cumulative total rows within the loop.

Please can anyone advise whether this is possible?

Thanks.
tp

[mlauber71]

@taylorpeter55 you can use the Variable Condition Loop End node to stop a loop once a condition is met. You can use temporary table to collect the results you already have.

Stop my loop if the column sum is greater than 50% of my flow variable

@kowisoft it could look something like this. Collection the iterating values in a temporary file and appending that at each step of the loop. And then like you have already done collect the sum of the column and then make a decision to sop (or not). Maybe not the most elegant way… Just make sure to reset the temporary file. One could also automate that by using a switch catching the first iteration of the loop (I have and example of that somewhere). [image] [image]

As an alternative you can try and build something with a Recursive Loop and define an end condition.

[taylorpeter55]

Hi @mlauber71,

Thanks for the info. I’ll take a look into these two options.

Thanks.
tp

[taylorpeter55]

@mlauber71 Just wanted to close this one out.

I went back to the drawing board and figured out that my workflow runs much better if i check all roles within one linear group of nodes, rather than check each one individually using a loop

Thanks again for your response to my original post.

tp