Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-02-22 03:54 PM
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
------------------------------
Answered! Go to Answer.
1 BEST ANSWER
Helpful Answers
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-02-22 04:15 PM
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
------------------------------
Shikhar Mishra
RPA Lead
Infosys Pvt Ltd
Pune,India
------------------------------
Shikhar Mishra
RPA Lead
Infosys
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-02-22 04:15 PM
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
------------------------------
Shikhar Mishra
RPA Lead
Infosys Pvt Ltd
Pune,India
------------------------------
Shikhar Mishra
RPA Lead
Infosys
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-02-22 06:36 PM
Thank you very much for your help, I will be applying this in my project.
------------------------------
Fatima Alcaraz
------------------------------
------------------------------
Fatima Alcaraz
------------------------------
