topic RE: Collection and Loop in Product Forum

Collection and Loop

FatimaAlcaraz — Mon, 07 Feb 2022 15:54:00 GMT

Hello, I have a collection of 254 rows, what I do with each value is to concatenate it with a semicolon (;) through a calculation. And I get the values in a data element as follows: 000123;000456;…
Now what I need to achieve is that it only takes 10 rows and does all that of concatenating the ten values as I mentioned before, what I am not knowing how to do is to validate that it only takes 10 rows at a time until it reaches the total number of rows of the collection which would be 254 rows initially.
I would appreciate any ideas how I could achieve this.
I attach a screenshot of what I've done so far.

------------------------------
Fatima Alcaraz
------------------------------

RE: Collection and Loop

Rambo27 — Mon, 07 Feb 2022 16:15:00 GMT

Hi Fatima,

If I understand the problem correctly ,
you need a string from loop collection with 10 collection values in one string and then so on .

You can put newline after the one 10 rows entering

On my understanding , you need two variable with counter set to 1 and recounter to 10 and then loop around and put increment as below diagram shows

Hope its helpful and let me know if any more questions

------------------------------
Shikhar Mishra
RPA Lead
Infosys Pvt Ltd
Pune,India
------------------------------

RE: Collection and Loop

FatimaAlcaraz — Mon, 07 Feb 2022 18:36:00 GMT

Thank you very much for your help, I will be applying this in my project.

------------------------------
Fatima Alcaraz
------------------------------