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
------------------------------
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
------------------------------
1 BEST ANSWER
Helpful Answers
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
------------------------------
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
------------------------------
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
------------------------------
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
------------------------------
